Dates not formatting correctly Closed

Question

Hi, I'm trying to format Dates as dd/mm/yyyy in excel, but my dates after 31/12/1999 are not been formatted correct. i.e 01/01/2010 is not being recognised as a date  

Configuration: Windows XP / Internet Explorer 6.0

ash_perez01 · Answer

Dear MB, 

Once you close the file and open it again, it might be that the date format is getting to the default one and hence you will have to set this specific format to the default one for having it recognized as a date. 

Thanks in advance.

Dates not formatting correctly

1 response

Similar discussions

Subscribe To Our Newsletter!