hello,

I'm using Excel 2004 in Mac OS X Tiger. I use dates in dd/mm/yy
format, and that's how it is set in my international preferences panel
(in Tiger) and how i formated the Excel column.

but then i type, say, 4/11/07 (to enter the date 4th nov 07) and excel
converts it to 11/04/07. it's like if excel understands that i'm
entering the date in mm/dd/yy format even though the system
preferences is dd/mm/yy.

why the heck excel is doing that?

thanks a lot
paula