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
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- Conditional format based on another cell containing text - Excel Forum
- Excel clear formatting - 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