I get the same as Sheeloo... if I type in Mar-09, the date becomes 3/9/2009,
not 3/1/2009... so my system is interpreting Mar-09 as mmm-dd and then
tacking on the current year.

--
Rick (MVP - Excel)


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
No. Mar-09 is often (usually, in my experience) interpreted as mmm-yy,
and therefore as 1st March 09.
Your settings must be different, Sheeloo.

I would suggest that Ranjith and his friend compare their settings in
Windows Regional Options (in Control Panel), as that is what usually
governs how input data is interpreted. Formatting of cells affects how
numbers are displayed once having been stored as a number.
--
David Biddulph

"Sheeloo" just remove all As... wrote
in message ...
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