International date format problem

  • Thread starter Andrew Black FirstClass
  • Start date
A

Andrew Black FirstClass

I'm having trouble with date formats in Excel 2004.

The only options available when using Format > Cells... > Date appear to be
m/d/y

I've got my region set to "United Kingdom" in the International preference
pane, but there are no d/m/y formats available.

I've looked through the preferences in Excel but there doesn't seem to be
anything relating to nationality or date formats.

Anyone got any idea how to change the available date format in Excel 2004?

Thanks!

Andy.
 
B

Bob Greenblatt

I'm having trouble with date formats in Excel 2004.

The only options available when using Format > Cells... > Date appear to be
m/d/y

I've got my region set to "United Kingdom" in the International preference
pane, but there are no d/m/y formats available.

I've looked through the preferences in Excel but there doesn't seem to be
anything relating to nationality or date formats.

Anyone got any idea how to change the available date format in Excel 2004?

Thanks!

Andy.
Click to expand...

If you don't like the available formats, create a custom one. Check help for
more details, or let us know the specific issue and format you'd like to
have the date appear.
 
Top