Issue with date formatting
Closed
HDW
Blocked Profile - Apr 4, 2014 at 11:07 AM
- Posts
- 1
- Registration date
- Friday April 4, 2014
- Status
- Member
- Last seen
- April 4, 2014
Blocked Profile - Apr 4, 2014 at 11:07 AM
Related:
- Issue with date formatting
- How to change date format in excel - Guide
- Describe the basic formatting of html documents layout. - Articles
- How to format write protected usb - Guide
- Samsung mobile format code - Guide
- How to change whatsapp time to 12 hour format - Guide
1 reply
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