View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
learningaccess learningaccess is offline
external usenet poster
 
Posts: 37
Default formatting issue- date format dominates

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!