VB Cell Loop insert same formula.

[skylinegtr]

Hi guys, can I have some help please.

I need to loop through each cell in column B
If the length of the text is 2 then a prefix of four Zeros should be added to make 6 characters
If its length 3 then 3 zeros to make it 6 characters.

I done it as a formula for one specific cell but can i have help converting it to VB?!!!
Please

Please Login or Register  to view this content.

[Domski]

Try this:

Please Login or Register  to view this content.

Dom

[Domski]

Note as a formula you could just use =TEXT(B114,"000000")

Dom

[skylinegtr]

Dom, that works a charm, thank you very much. I really really appreciate the help!

[skylinegtr]

Note as a formula you could just use =TEXT(B114,"000000")

Dom

Doh so easy and I did it the long way!

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save