Previous Topic Next Topic

Date Formats

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

1 response

Answer 1 / 1
yg_be Posts 23449 Registration date Sunday June 8, 2008 Status Contributor Last seen January 28, 2025 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.

Similar discussions

How can I convert Apple Music to MP3
nikigreen -
nikigreen -

8 responses
How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
Excel format
D -
sheryljohnson -

1 response
enter date in dd-mm-yyyy
sam -
fdibbins -

2 responses
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS
asmfiaz -
Mazzaropi -

2 responses