Macro to Format Cells into a String

Looking for assitance, I have 2 columns that need to be reformatted so that they can go into an access file.

• Row R, needs to have 6 digits, and if the cells do not, they need to be proceeded by 0's
• Row T, needs to have 9 digits, and if the cells do not, they need to be proceeded by 0's

So in cell R2, if the value is 23de, then I need it to say 0023de
in cell R3, if the value is 256, then I need it to say 000256

So in cell T2, if the value is 123, then I need it to say 000000123
in cell T3, if the value is 234567, then I need it to say 000234567

but it needs to stay like this so it can go into an access database? A suggestion to one of my previous threads by MarvinP says to

Please Login or Register  to view this content.

will help with 8 digit long strings, so I assume, changing the 8 to a 9 will help, but my newly found concern is that it might be easier just to make a macro, as this task needs to be performed daily.

@venkat1926, you might want to check out the String function in VBE which works in similar (not identical) fashion to the native REPT function