Type in: MAR-2009
it will give you 3/1/2009


"Ranjith Kurian" wrote:

when i type any date in mmm-yy(Mar/09) format the excel sheet allways shows
the date in formula bar as 03/09/2009
why its so?
if i type the same date in my friends system it shows as 03/01/2009

how to change the setup