A problem with dates and I don’t know what to do

[filo666]

Hi, I have some date problem, in my computer control panel de date format is
dd/MM/yy (I’m in Mexico), in my excel workbook I have in some cells of two
sheets the personalized date format as dd/mm/yy (also I’ve tried the date
format 14/03/05), now the problem:
When I try to put the date I type 06/12/05 (December 6, 2005) but I don’t
know why excel change the numbers and type 12/06/05 when I deselect the cell,
then, in a sheet that prints the bill order, the date is considered as
12/06/05 I mean “June 12, 2005†where should say December 6, 2005.
I don’t know what is happening; please help me because It’s driving me crazy.

TIA

 

[Kevin B]

Go to the Control Panel in Windows, select Regional Options, click on the
Date tab and set your default date format there. You can also set your
location from here "Spanish (Mexico)" and this may also correct the problem.