Date format in microsoft excel

A

aznan

Hi, i set the date format in Microsoft Excel cells to dd/mm/yy but why is it
that if i type 22/4 it doesn't put it in 22-04-07 date format.

If i type 4/22 it then puts it in 22-04-07 date format

Can this be done ? So that if i typed 22/4 then it automatically puts it in
22-04-07 format.

Please help / Advise
 
A

aznan

Hi, thanks so much , appreciate your help very much. I did the changes below
and everything seems fine.

Control Panel > Regional Settings > Regional Options tab > Customize > Date
tab and change the “short date format†to dd/MM/yy
 
Top