Help on Formatting Dates

Closed
MB - May 5, 2010 at 07:14 PM
venkat1926
Posts
1864
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 reply

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