| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Conversion Help
I have a macro which imports a date into one of my excel cells from a .csv
file in a strange format. For example, if the date is 5-20-09, it is imported in this format... ##20090520123345 I want the macro to change it to... 05/20/09 Currently I am searching the cell and if I find the XX in the first two positions, I am just replacing the whole string with DATE. The problem is that the date might be a date other than today. How can I manipulate and truncate the string once I find the entries that start with XX? The numbers 12345 in the above example are not constant. -- Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Conversion | Excel Discussion (Misc queries) | |||
| Date Conversion | Excel Discussion (Misc queries) | |||
| Date conversion | Excel Worksheet Functions | |||
| date conversion | Excel Discussion (Misc queries) | |||
| Date Conversion | Excel Programming | |||
Threaded Mode
