yet another date format problem


P

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
 
Ad

Advertisements

D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top