You could change your Windows Regional Settings
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gerry" wrote in message
...
Presently have 27/05/2008. How do I format to get 27.5.08?

I have tried d.m.yy but it does not change.

Excel 2000.

TIA



~~~~


Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~