Tech Support Guy banner
  • Please post in our Community Feedback thread for help with the new forum software! If you are having trouble logging in, please Contact Us for assistance.
Status
Not open for further replies.
1 - 4 of 4 Posts

·
Registered
Joined
·
14 Posts
Discussion Starter · #1 ·
Do any of you gurus know why when I enter my dates as 3/30/04 they automatically change to 38076? I have tried to format the cell the way I want it but they won't change. Did I hit a key command that changed the format without knowing it? The strange thing is when I began working with the spreadsheet it was fine. Then I entered a date a few days later and they all changed to the 38076 format.

Please help if you can.

jhorsley
 

·
Registered
Joined
·
2,702 Posts
>> Did I hit a key command that changed the format without knowing it?

Do they show up right in the formula bar? (What I'm thinking is a long shot because it should've affected col widths too, but) you may have switched to Formula view.

Try pressing the key below ESC/left of [! over 1] while holding down CTRL.

If not, can you fix them by FormatPainting from an OK cell in another workbook?

HTH,
Andy
 

·
Registered
Joined
·
2,702 Posts
jhorsley, I've a list as long as your arm of people who'll attest that I'm neither of those, in any order. :D

You're welcome,
Andy
 
1 - 4 of 4 Posts
Status
Not open for further replies.
Top