Does anyone have some simple code (not formula) that I can use to convert
American date format to English format. eg. 12/25/06 to 25/12/06. It will
have to take into account single and double digits. I then want to be able to
attach the macro to a button for quick conversion.

Cheers,
Ant.

Are the values actually dates or text ?
If dates, record a macro whilst you perform the change in
Format>Cells>Number.
If on XL2002 and later, maybe the date formats marked "*" will be useful. I
understand they do not change with differences in Windows Regional Settings.

If text, look into DateSerial and build your new date from the old.

Not sure what you mean by "take into account single and double digits".

NickHK

"Ant" <(E-Mail Removed)> wrote in message
news:0E815652-F49C-472D-B631-(E-Mail Removed)...
> Does anyone have some simple code (not formula) that I can use to convert
> American date format to English format. eg. 12/25/06 to 25/12/06. It will
> have to take into account single and double digits. I then want to be able
to
> attach the macro to a button for quick conversion.
>
> Cheers,
> Ant.
>