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! :)
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.