Issue with date formatting
Closed
HDW
Posts
1
Registration date
Friday 4 April 2014
Status
Member
Last seen
4 April 2014
-
4 Apr 2014 à 08:21
Blocked Profile - 4 Apr 2014 à 11:07
Blocked Profile - 4 Apr 2014 à 11:07
Related:
- Issue with date formatting
- Excel clear formatting - Guide
- How to change date format in excel - Guide
- How to change date format in openoffice - Guide
- Excel conditional formatting based on date - Guide
- Formatting windows 7 - 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
