Mar-09 should be stored as 9th day of March of 2009 in both systems...
Yours will show it as 3/9/2009 as yours seems to have mm/dd/yyyy as the
system date format. Your friend's system should show it as 9/3/2009....

If you leave out the year, current year is assumed...

"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