| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create a date conversion in MS Excel using VBA
Hi,
I have a file that is imported from Attachmate Extra!. The dates appear in Excel as i.e. 106/04/14, which represents April 14, 2006. How can I convert all these dates to the standard 04/14/2006 format using VBA? I have NEVER seen a date format like the one from Attachmate. Please help. Thanks! Sandspirit |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Losing date values upon conversion from EXCEL to CSV | Excel Discussion (Misc queries) | |||
| Excel date conversion-UK to US | Excel Worksheet Functions | |||
| Turning off Date Conversion in Excel | Excel Discussion (Misc queries) | |||
| What is the best way to create a conversion table in Excel ? | Excel Discussion (Misc queries) | |||
| AS400 Date value conversion to Excel | Excel Programming | |||
Threaded Mode
