Date Formats

Closed
DJL - Updated by DJL on 3/12/16 at 09:06 AM
yg_be Posts 22679 Registration date Sunday June 8, 2008 Status Contributor Last seen April 14, 2024 - 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.

1 response

yg_be Posts 22679 Registration date Sunday June 8, 2008 Status Contributor Last seen April 14, 2024 5
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.
0