Excel Regional Date Format Options

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top