Date Formats
Closed
DJL
-
Updated by DJL on 3/12/16 at 09:06 AM
yg_be Posts 23466 Registration date Sunday June 8, 2008 Status Contributor Last seen February 12, 2025 - Dec 3, 2016 at 01:23 PM
yg_be Posts 23466 Registration date Sunday June 8, 2008 Status Contributor Last seen February 12, 2025 - Dec 3, 2016 at 01:23 PM
In Excel, why do I set date format to custom mm/dd/yy yet have to enter the date as yy/mm/dd for it to appear correctly on the worksheet.
I used to enter mm/dd/yy and it appeared correctly.
I used to enter mm/dd/yy and it appeared correctly.
Related:
- Date Formats
- Excel date format dd.mm.yyyy - Guide
- Enable support for other file formats, such as pdf and xps - Download - Other
- Whatsapp date format - Guide
- How to set date format dd-mm-yyyy in vivo ✓ - Office Software Forum
- How to change excel date format - Guide
1 response
yg_be
Posts
23466
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
February 12, 2025
5
Dec 3, 2016 at 01:23 PM
Dec 3, 2016 at 01:23 PM
I believe that the format of the cell does not influence the way Excel makes a date from the characters you enter (or leave it as a string of characters) : the format only influences the way the value is displayed.