PDA

View Full Version : I hate the Excel date system



Tempestv
03-22-2008, 12:57 AM
I have some stuff to enter into a Excel spreadsheet that consists of two numbers separated by a dash. Excel keeps interpreting it as a date and changing it into a different format. How can I make it input my data correctly?

tutipute
03-22-2008, 11:34 AM
You neeed to format the cells correctly. ..
By default, the 'General' format will convert such strings to a date.

Just right click a cell (a column, or just the entire table...) and choose 'Format Cells...'. Once you are in, just choose 'Text' from the Category list.

Best of luck! :)