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 |
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 . |
All times are GMT +1. The time now is 05:33 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com