Thread: date format
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default date format

format the cell as text first or put a ' in front of the data, the ' want
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

"johnson5" wrote in message
...
I need to enter data into excel and have it remain in "general" format

rather
than have it become a date (eg when i enter 3/1952 it becomes 3 march

1952)
this happens with any viable number that can conceivably be interpreted as

a
date (5/2500 also becomes a date!). How can i force the cell to maintain

the
format?