Default date format

P

peacefulterran

Hi there,

The default date format, which supposedly is based on the International
preference panel in Mac OS X Tiger (10.4.3), seems to be broken. It
seems it doesn't read the custom format specified there (as it did
before? - I'm not sure).

I have set up a custom short date format in the form of 2005/12/31 in
the International preference panel. From what I've read, Excel was
supposed to use that format as default when recognizing data being a
date. It recognizes it alright, but displays it as 12/31/2005 (which
is the default date format for US English in International preference
panel).

So, I guess that Excel can read the default date format from the
system, but not the customized date formats. Can you fix this, please,
Mac dev team?


Frederic
 

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

Date input format 0
Date entry not respecting my locale / Region 1
International Date Formats in Excel 4
yet another date format problem 3
British Date Formats 2
International Date Cell Format 1
Date Formats for Cells Do not match System Date Formats 5
Can't sort by date 2

Top