| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert date/time formats differently? | Excel Discussion (Misc queries) | |||
| How to easily convert US to UK date formats? | Excel Worksheet Functions | |||
| Date custom formats | Excel Discussion (Misc queries) | |||
| Macro or VBA to convert Excel sheet to JPEG, DICOM or TIFF formats | Excel Worksheet Functions | |||
| I need a macro to convert my date formats into a custom layout. | Excel Programming | |||
Threaded Mode
