Excel 97 default date format

  • Thread starter Thread starter GB
  • Start date Start date
G

GB

How do I change the default date format to show yyyy rather than yy, please?

Geoff
 
Geoff

That is controlled by Windows settings.

Make changes at Control Panel>Regional Settings for "Short Date"

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Gord Dibben said:
Geoff

That is controlled by Windows settings.

Make changes at Control Panel>Regional Settings for "Short Date"
Click to expand...

Thank you Gord, that does the job perfectly.

It never occurred to me to alter the short date setting to the same as the
long date setting. It has obviously had some effects on windows elsewhere,
but hopefully these are livable with.

Geoff
 
I have never run into any Application that objected to the "short date"
settings being same as "long date".

Gord
 
You must log in or register to reply here.

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

How to change the default format for date? 3
Preserving date format 1
Date in footer 3
Excel 2002: How to make the date format uniform ? 1
Weird date format problem 2
Date Formats 1
Date format 2
Wrong date format in header 1

Back
Top