Need to type 5-10, 11-20 etc. in excel. everytime i do, it autocorrects it to a date. How can i turn this of? I have tried formatting the cell, but no luck.
2007-12-16 01:47:44 · 4 answers · asked by Bobsonnyjim 1 in Computers & Internet ➔ Software
Another option is to use an apostrophe as the first character. (IE, type '5-10). This will tell Excel to handle the contents of the cell as text. The ' will not be displayed in the cell.
Hope this helps.
2007-12-16 02:50:36 · answer #1 · answered by SharksRule 5 · 2⤊ 0⤋
Formatting the cell should have taken care of it. If you still have problems you might try going into your default windows settings for your computer which you can find in the Control Panel. You should find it under the Regional and Language Options. Click on the Regional Options tab then click on the Customize button. Then select the Date tab. That should show your default short date format and default long date format for Windows. Your short date format may need changed if it is not in the format you would like it in.
2007-12-20 00:34:01 · answer #2 · answered by devilishblueyes 7 · 0⤊ 0⤋
When you format the cell, just choose text, not number.
2007-12-16 02:03:36 · answer #3 · answered by amontef 7 · 0⤊ 0⤋
Format the column as text.
2007-12-16 02:02:59 · answer #4 · answered by Hetep 2 · 0⤊ 0⤋