Customise Date Format
Jaleel
That doesn't work.
Thanks for the suggestion.
~~~~
Gerry
~~~~
FCA
Stourport, England
Enquire, plan and execute
~~~~~~~~~~~~~~~~~~~
Jaleel wrote:
Hi,
Go to format cells. Under Number tab you can see Date. Click that
and select the *14/03/01. Then select Custom and select dd/mm/yy and
under the Type you manually put dd.mm.yy
Try this.
Regards,
Jaleel
"Gerry" wrote:
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
~~~~~~~~~~~~~~~~~~~
|