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.
 

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
International Date Format 0
How to set the default date format to D/M/Y? 13
Date entry not respecting my locale / Region 1
International Date Formats in Excel 4
Date format 2
yet another date format problem 3
International Date Formats in Excel 9

Top