yet another date format problem

[Paula]

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

 

[Dave Peterson]

If you don't get an answer in this newsgroup, maybe you'll get one here:
news://msnews.microsoft.com/microsoft.public.mac.office.excel