Search results for query: *

Hello, Thanks for all the great info. I did use Salem's code and it worked perfectly. Thanks.

Hello, I need to know how to rename a bunch of files i have. All the files are currently in the same format and I need to do 3 things to the name. First I need to add a leading W to the name, then where the name ends with the extention .dwg i need to make this uppercase (.DWG) and the 3rd...

Ok, I was able to get this done by formatting close to what bluedragon suggested2. I simply highlighted all the rows in that column and did the format, number, custom and put 00 The largest number i had was 2 digits so this did put a leading 0 in. Thanks for all the help with this.

rDodge, This works for new entries but I have an existing spreadsheet that has many many existing rows that I need to convert over to the leading 0. Is there a way to convert the existing data?

Hello, can anyone tell me how I can add a zero in front of a number in excel. I have a column that has numbers such as 5 7 23 16 80 and I need them to be 05 07 023 016 080 Does anyone know how I can do this? Basically I just need to add one zero in front of each number. I'm using excel...

Actually the cobol is micro focus cobol on a pc. Thanks for all the input. I was able to use the program that saginaw sent me and it worked perfectly. I was able to get linecounts from several hundred programs. Thanks again Saginaw you saved my day.

ok, actually this doesn't have to be exact. Comments should not count in the linecount but hey, there aren't many of those anyway. One statement on multiple lines should count as one statement. Copy books should count and I would be satisfied to have a count for the total number of lines in the...

Hello, Unfortunantly not trying to impress the boss. I have to do this. Anyway, the link you gave does not seem to work. It is over 3 years old and I don't believe it's there anymore.

Hello, I have an application that I need to provide a count for the total number of lines of cobol code. Does anybody know the best way to do this? Does anybody know of any utility that can do this or a maybe a freeware or shareware program that could be downloaded? Any help will be...

Hello, Thanks for the help. I did use SamBones code (since he saved me yesterday) and it worked perfectly. Thanks so much.

I have one more problem with the renaming of files. Would appreciate your help. I have many files named in the format of xx-xx-xxx-xxx-xx.cgm exp. 21-10-150-275-02.cgm I simply need to get rid of the last two digits (the two digits just before the file extension .cgm) file...

YES!! This absolutely did exactly what I needed. Thanks a million SamBones. You saved my day!!

Hello, Can anyone help me in renaming about 1000 files I have. The file names are like 21-10-03-902-02.tif The change i need to make is in the third set of digits (where the 03 is in this example). I need to make the 2 digits to be 3 digits with a leading 0. In the above example...