Excel Regional Date Format Options

G

Guest

A client of ours in NZ is complaining that date format options for English
(New Zealand) have changed from older versions of excel (they are using 2003)


Some of their spreadsheets have dates formatted as dd-mmm-yy, mmm-yy and
dddd,dd,mmm but these options do not exist anymore.

Is there anyway to add options to this list without using the custom format
option?

Thanks,

Jesse
 
J

Jim Rech

I just compared the Excel 97 and Excel 2003 built-in date formats and they
are mostly unchanged. 2003 has a few more but I don't think there were any
subtractions. The formats dd-mmm-yy and mmm-yy are right there (appearing
as 14-Mar-01 and Mar-01 in the list). dddd,dd,mmm isn't and never was as
far as I can tell. The available formats are affected by your Windows
control Panel regional settings to some extent. So if they changed at the
time of the Excel 2003 upgrade then the date formats may have too. I must
confess I did not switch to NZ settings to see what happens.
 

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

Top