You need to look in a mirror. You want free, accurate advice, and you are
getting it. What more do you want? You're welcome to take your business
elsewhere. But if you follow the advice given in this newsgroup, no matter how
it's worded, you will never go wrong.

--
Regards,
Fred


"learningaccess" wrote in message
...
Wow... someone is in a bad mood! Have you heard of email etiquette? Really,
there is no need to be so nasty.

I had no problems doing this in general the other day. Get a personality.
--
Thanks!


"Stephen" wrote:

You have already received an explanation of this. In Excel, 2-3 and 4+ are
NOT numbers. You cannot enter 2-3 in General format (except preceded by an
apostrophe) without it going wrong. Whatever you did "the other day" was no
different - you have just confused yourself.

"learningaccess" wrote in message
...
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!