Date Formatting

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
I have formatted a cell for month, day & year as follows: 00/00/00. I then type 042110 and it appears as 04/16/15. Any suggestions?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What are you trying to do exactly ? dates are formatted using MM, YY, YYYY etc. 00, # etc are for numbers
0