Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help in macro
Hi,
I run a text report from our software & then I open that text report into XL (Delimited Function). One of the column has time & it is in the order of HHHH:MM:SS Sometimes if the column has only minutes & seconds, I will see :MM:SS OR if only seconds then :SS - I have to convert the formating of every single cell & manually change the numbers. I am using XL 97 & its really pain in the neck to change every single cell. I am wondering if anyone can tell me an alternate way of handling this issue or create a macro to add 0's automatically infront of the colons instead of doing it manually. Thanks, Kash |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help in macro
Try the FORMAT function in VBA . . .look at Format in the
help for VBA. It gives several pretty good examples. I'm sure something there might work for you . . .just play around with it until you get what you want. Hope that helps. JRL -----Original Message----- Hi, I run a text report from our software & then I open that text report into XL (Delimited Function). One of the column has time & it is in the order of HHHH:MM:SS Sometimes if the column has only minutes & seconds, I will see :MM:SS OR if only seconds then :SS - I have to convert the formating of every single cell & manually change the numbers. I am using XL 97 & its really pain in the neck to change every single cell. I am wondering if anyone can tell me an alternate way of handling this issue or create a macro to add 0's automatically infront of the colons instead of doing it manually. Thanks, Kash . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |