Someone please help! I just need the following in general format:

0, 1, 2-3 and 4+

2-3 keeps changing to Feb 3rd. I just need 2-3 and 4+ in General number
format. Worked the other day ... no problem. Don't know what the deal is
today.


Thank you.
--
Thanks!


"Peo Sjoblom" wrote:

2-3 is not a number in Excel so Excel guesses what you are trying to do and
it guesses that you are trying to enter a date. Btw, why would you need
general format?


--


Regards,


Peo Sjoblom


"learningaccess" wrote in message
...
thank you, but i need the format in general for a map point application.
map
point won't map 2-3 and 4+ as text but it worked no problem the other day
with general format.

Why won't general format stick?


--
Thanks!


"Peo Sjoblom" wrote:

precede the entry with an apostrophe ' or format as text


--


Regards,


Peo Sjoblom


"learningaccess" wrote in
message
...
Hi,

I'm trying to put general numbers in a column as follows : 0, 1, 2-3
and
4+.

2-3 keeps changing to Feb 3rd no matter that I keep formatting General.

How can I stop this? Please help!

Thanks,
Chris
--
Thanks!