Very Simple Question

A

Adios

Help !
This may sound unbelievably silly but I can not sort it out.
I want to type 1-10 in an excel cell but everytime I do that it
converts it to a date. How do I stop this?
 
P

Paul B

Adios, format the cell as text before you enter the data or put a ' in front
of it, the ' will not show

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
B

Bob Phillips

Format the cell as text or precede it with a single apostrophe '

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top