Issue with date formatting
Closed
HDW
Posts
1
Registration date
Friday April 4, 2014
Status
Member
Last seen
April 4, 2014
-
Apr 4, 2014 at 08:21 AM
Blocked Profile - Apr 4, 2014 at 11:07 AM
Blocked Profile - Apr 4, 2014 at 11:07 AM
Hello,
For some reason, when I insert date formatting into Excel on my work computer, the numbers that appear in the spreadsheet are completely different than the numbers I have inserted. Example: Format is set to DD/MM/YY. I insert today's date, "040414". This populates on the sheet as "24/08/10". Why would this happen? Any suggestions? I've tried new worksheets and different date formats with the same strange results. Thank you in advance for any suggestions.
Best,
HDW
For some reason, when I insert date formatting into Excel on my work computer, the numbers that appear in the spreadsheet are completely different than the numbers I have inserted. Example: Format is set to DD/MM/YY. I insert today's date, "040414". This populates on the sheet as "24/08/10". Why would this happen? Any suggestions? I've tried new worksheets and different date formats with the same strange results. Thank you in advance for any suggestions.
Best,
HDW
Related:
- Issue with date formatting
- How to change date format in excel - Guide
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- How to format windows 7 with keyboard - Guide
- Formatting usb mac - Guide
1 response
Ok, what is happening, is Excel is converting your number into that many days after Jan 1 1900. 40414 days after Jan 1 1900, is 8-24-2010.
You wil have to enter the data as a date format, not a number.
I have started to try to get the conversion, but My phone won't stop ringing, I do appologize for delays.
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
You wil have to enter the data as a date format, not a number.
I have started to try to get the conversion, but My phone won't stop ringing, I do appologize for delays.
"If you can't soar with the eagles, then don't fly with the flock!" - Oliver Sykes; Bring Me The Horizon
