date format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
thanks for that but i am using the data with a vlookup and the format needs
to match data imported
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default number format in Excel 1
Very difficult query! 4
F2 shortcut and strange formatting of date fields 1
Excel date formats 2
Remove date format? 3
Cell Formating 2
Excel date formatting 1
How do I change default number format? 2

Back
Top