Excel VBA Adding Zero in Number String

[Guna13]

Since I am only new to Visual Basic, I don't know much about programming. I have now manually processed this work.

In my Organization Fin Companies 001 to 999 Order, I download the Master dump file from the ERP system. Rather than showing all <100 Fin Companies, it shows only two digits instead of three digits

To update '002 or '083 or '088 in this format, I need to update ('xxx) this format manually. What is the best way to update this format via VBA. I have more than 3 laksh lines in my Master data dump at the moment

This Special format didn't work for my formula when I tried that General function.

Fin Comp
12
23
34
98
234
344
434
233
848
999
343

I need output should be

Fin Comp
'012
'023
'034
'098
234
344
434
233
848
999
343

 

[Guna13]

I am login off for the night, hopefully someone in a different time zone will pick it up overnight.

Hi Alex Sir, Nobody reply to me... kindly support me