A
agreen
Hi all,
I need some help in setting up a VBA macro that will convert compressed
information from 2 columns into 1 formatted column. The first column
contains the compressed date information yyyymmdd, and the second
column cotains a compressed time stamp hhmmss (sometimes hmmss) in 24
hour time. Both columns are defined as "general".
This code will be put into a macro that is performing an import of an
ascii file. Not sure if it is better to do it as part of the import, or
after, once the data is in the sheet.
example:
c4: 20040705 d4: 85250 = 2004/07/05 08:52:50
c5: 20040706 d5: 175018 = 2004/07/06 17:50:18
Regards
Andrew Green
I need some help in setting up a VBA macro that will convert compressed
information from 2 columns into 1 formatted column. The first column
contains the compressed date information yyyymmdd, and the second
column cotains a compressed time stamp hhmmss (sometimes hmmss) in 24
hour time. Both columns are defined as "general".
This code will be put into a macro that is performing an import of an
ascii file. Not sure if it is better to do it as part of the import, or
after, once the data is in the sheet.
example:
c4: 20040705 d4: 85250 = 2004/07/05 08:52:50
c5: 20040706 d5: 175018 = 2004/07/06 17:50:18
Regards
Andrew Green