I need a macro to convert my date formats into a custom layout.
 

Frank, I see your point. But according to the nature of work, new dates will
keep coming into the workbook "generally" in the old "dd.mm.yyyy" format.
Thus IMHO having a button to solve this problem whenever required seems both
practical a logical.
Thanks for your suggestions anyway...
Martyn

"Frank Kabel" wrote in message
...
Hi
why don't you just change the format of these cells ('Format - Cells -
Custom' or 'Format - Cells - Date'). If you want a button you may
record these steps (Tools- Macros - Record Macro') and assign a button
to this macro

--
Regards
Frank Kabel
Frankfurt, Germany