Very Simple Question

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?

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

"Adios" <Adios.2690ln_1145008501.2111@excelforum-nospam.com> wrote in
message news:Adios.2690ln_1145008501.2111@excelforum-nospam.com...
>
> 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?
>
>
> --
> Adios
> ------------------------------------------------------------------------
> Adios's Profile:
http://www.excelforum.com/member.php...o&userid=33490
> View this thread: http://www.excelforum.com/showthread...hreadid=532903
>

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adios" <Adios.2690ln_1145008501.2111@excelforum-nospam.com> wrote in
message news:Adios.2690ln_1145008501.2111@excelforum-nospam.com...
>
> 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?
>
>
> --
> Adios
> ------------------------------------------------------------------------
> Adios's Profile:
http://www.excelforum.com/member.php...o&userid=33490
> View this thread: http://www.excelforum.com/showthread...hreadid=532903
>