Excel 97 default date format

G

Gord Dibben

Geoff

That is controlled by Windows settings.

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

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
G

GB

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
 
G

Gord Dibben

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

Gord
 

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

VBA - exporting serial letters to single documents 0
Table of content - format does not get saved 2
Publisher is filling blank lines with data 2
How to add day to PWA 2016 date format? 0
Countdown macro - display settings 2
Date Formats 4
Date Format 10
Visio 365 Change default connector arrow style 0

Top