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 date format dd.mm.yyyy - Guide
- How to clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- How to format windows 7 with keyboard - Guide
- Whatsapp date format - 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