Previous Topic Next Topic

Help on Formatting Dates

Closed
MB - May 5, 2010 at 07:14 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 5, 2010 at 09:03 PM
Hi, I'm trying to format Dates in Excel using custom and dd/mm/yyyy.

but Excel is actually getting confused and this the mm is the dd.


Any date after 31/12/1999 is not been formatted correctly.

It looking like a date such as 01/01/2010 is not being recognised as a date




What am I doing wrong??

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
May 5, 2010 at 09:03 PM
check your regional dispensation how dates are entered in excel.