Hi all,

I've found threads that discuss adding zeroes to create a fixed amount of digits but I'm interested in something different.

First I have this:

A1= 123
A2= 456
A3= 789

Then changing the variable AddZeroes to 5 leads to:

A1= 00000123
A2= 00000456
A3= 00000789


How to do this with VBA?

Help with this would be much appreciated