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
 
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

How to enter a date in DD-MM-YYYY format 2
Date Format Problem. 2
In Excell-2000 where do I set format for date? 5
Date Format 3
Very strange date format behavior: 06 > 2006 / 07 > 07 5
Date Format 1
Date format in Indian style 1
convert to date format 3

Top