Find value starting with "1" in column H

[vijay2482]

Hi all,

I have a excel sheet in which there may be values starting with "1" in column H ( column 8)
eg:"1530501" (7 digits)
In this case I like to add 3 zeros ("000") in front of this value.
Expected value: 0001530501

I wrote the below code, but not sure what I wrote is correct or not.

Please Login or Register  to view this content.

I'm not sure whether its right to use "+".

Any help will be helpfull.
Thanks in advance.

[shg]

& is the string catenation operator. The + will work in most instances, but the & makes it abundantly clear.

There is no Length property of a range. Maybe

Please Login or Register  to view this content.

[vijay2482]

I used the below code:

Please Login or Register  to view this content.

There is no difference in the output
Any help please

[royUK]

You need more than that

Please Login or Register  to view this content.

I don't think you will have true numbers because they start with a zero,you could of course format the column

[vijay2482]

Thanks for your reply.

what does

Please Login or Register  to view this content.

code mean?
I did not get the desired output.

[shg]

Two ways you could do this -- one changes the number formatting, the other changes the text to a string:

Please Login or Register  to view this content.

[vijay2482]

Thanks a lot for your help.
I tried your 1st method of code.
It did exactly what I needed.

Thanks once again