How do I disable Excel from automatically changing my data when I first open the excel sheet?
I know how to stop it once I have opened the sheet and before entering in information, I can format the column as text and it will not think my numbers are dates or something, but what I need to know is.............
Can I set Excel not auto correct any data in the sheet when I open it?
Here is an example of typical entries that are changed frequently:
Long Numbers
ORIGINAL ENTRY: 625617000001
EXCEL SHOWS: 6.25617E+11 (Even when the column width is expanded)
Other Issues
ORIGINAL ENTRY: AUG11
EXCEL SHOWS: 11-AUG
ORIGINAL ENTRY: 11-12-04
EXCEL SHOWS: 11/12/2004
These are actually part numbers, not dates, or scientific numbers. I do not want Excel to change these entries, especially when I have thousands of variations of the above examples. Trying to correct all of them would be a nightmare.
(I am using Excel 2003)
Thank you for your help!
Bookmarks