Customise Date Format
 

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
~~~~~~~~~~~~~~~~~~~

Customise Date Format
 

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
~~~~~~~~~~~~~~~~~~~

Customise Date Format
 

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
~~~~~~~~~~~~~~~~~~~

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
~~~~~~~~~~~~~~~~~~~

Customise Date Format
 

Bernard

Your suggestion may have got me a result. I will need to test a bit
further.

It has no effect on an existing 27/05/2008 but if you copy the value
equivalent to 27/05/2008 using Paste, Special, Value into a
preformatted cell it produces 27.5.08. Using Edit, Find I could make
changes but it is a long winded approach.

Thanks.



~~~~


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


Bernard Liengme wrote:
You could change your Windows Regional Settings
best wishes

"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
~~~~~~~~~~~~~~~~~~~

Customise Date Format
 

for the Custom format use

dd"."mm"."yyyy

"Gerry" wrote:


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
~~~~~~~~~~~~~~~~~~~