Help on Formatting Dates

Closed
MB - 5 May 2010 à 19:14
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 5 May 2010 à 21:03
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??

Related:

1 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
5 May 2010 à 21:03
check your regional dispensation how dates are entered in excel.