American date conversion Macro
 

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.

American date conversion Macro
 

Are the values actually dates or text ?
If dates, record a macro whilst you perform the change in
FormatCellsNumber.
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" wrote in message
...
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.