Excel calculated date format

[Alan Freeman]

While I realise that MicroSoft is an American company, not all of us want
american the format for our spreadsheets!!!

I have my machine set for UK formats - which is fine for general computing,
but in Excel the date format keeps displaying MM/DD/YY format.

Even if I change the format to DD/MM/YY then use formula or VBA to generate
date information it defaults to MM/DD/YY. This is both annoying and defats
the object of setting the PC number format to UK.

Is there a PERMANENT fix to change this?? The only one I can see is to
scrap Excel and go for A.N.Other package!!!!!! The problem is they all come
from the USA.

 

[JE McGimpsey]

While I realise that MicroSoft is an American company, not all of us want
american the format for our spreadsheets!!!

I have my machine set for UK formats - which is fine for general computing,
but in Excel the date format keeps displaying MM/DD/YY format.

Even if I change the format to DD/MM/YY then use formula or VBA to generate
date information it defaults to MM/DD/YY. This is both annoying and defats
the object of setting the PC number format to UK.

Is there a PERMANENT fix to change this?? The only one I can see is to
scrap Excel and go for A.N.Other package!!!!!! The problem is they all come
from the USA.

XL gets its default date format from MacOS via the System
Preferences/International pane. Verify that it's set correctly there.

If it is, please post back with the version of XL and MacOS you're using.