American date conversion Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top