Date Formats

Closed

DJL - Updated by DJL on 3/12/16 at 09:06 AM
yg_be Posts 24281 Status Contributor - 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.

Date Formats
How to change date format in excel - Guide
How to change date format in openoffice - Guide
Enable support for other file formats, such as pdf and xps - Download - Other
Excel conditional formatting based on date - Guide
Clear formats excel - Guide

1 response

Answer 1 / 1

yg_be Posts 24281 Status Contributor 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

How do i change date format in (dd.mm.yyyy)

Excel format

enter date in dd-mm-yyyy

Similar discussions

Subscribe To Our Newsletter!