General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Excel 2002 Cell Formatting Problem
Please forgive me if this question has been asked and answered.
In Excel 2002, why does it automatically reformat a certain number to Date format?
For example, I am entering the number 02-04-2031. This is a part number, not a date even though it "looks" like it could be a date. It must have the leading "0" and the dashes.
I can change the cell format to "General" but when I enter the part number it changes to "2/4/2031". I can also change the cell format to "Number" but it changes to "47883".
I have looked in the options in Excel and I don't see anything to change. I have also looked on Technet.com, no help there either.
I would greatly appreciate any suggestions anybody might have as to a work around for this problem.
Thanks!!!
Russell Peeples