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
Related:
- Issue with date formatting
- Excel clear formatting - Guide
- Excel conditional formatting based on date - Guide
- How to change date format in excel - Guide
- Formatting windows 7 - Guide
- How to change date format in openoffice - 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
