Can anyone help with the program Excel?? I'm trying to enter the text 1-2 in one of the cells, but it comes up as January 2. How can I turn off this automatic date thing? Thanx so much.
2007-08-21 04:56:28 · 4 answers · asked by Anonymous in Computers & Internet ➔ Software
You can enter a single quote first
Example: '1-2
2007-08-21 05:04:39 · answer #1 · answered by tancy2411 4 · 0⤊ 0⤋
Tancy2411 and Clinky are both right. Either one will do the trick.
The apostrophe before the text tells Excel to evaluate what you enter after the apostrophe as text instead of as a date. Formatting the cell as the Text format will do the same thing.
If you are just entering the text in one cell, use the apostrophe since it is quicker.
If you are going to be entering text like this in multiple cells, then select the range and format the cells in that range as Text before you enter the text.
2007-08-22 12:26:44 · answer #2 · answered by devilishblueyes 7 · 1⤊ 0⤋
go to format cell, select text, that should work.
2007-08-21 12:07:27 · answer #3 · answered by clinky 3 · 1⤊ 0⤋
try to key " ` " follow by the number.
or click on the cell use format cell > change to wat you want
hope this helps
2007-08-21 12:05:21 · answer #4 · answered by herbman76 2 · 0⤊ 0⤋