Date Formatting

Closed
joelafores - May 6, 2010 at 01:10 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 6, 2010 at 01:45 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 6, 2010 at 01:45 PM
What are you trying to do exactly ? dates are formatted using MM, YY, YYYY etc. 00, # etc are for numbers
0