Retaining leading zeros

Hi All,

I need help stopping excel removing leading zero's from a range of numbers I have on a worksheet, I have searched this and other forums and am unable to find a solution. The problem is I have a range of Alphanumeric characters which I need to increment. (Please see attached) the problem is I need to remove the character to increment the numbers.
This is the code I have so far

Please Login or Register  to view this content.

unfortunately when I am left with only the number excel removes the leading zeros.

Any help would be much appreciated

Create a Custom NumberFormat such as "00000" which will display 123 as 00123

Please Login or Register  to view this content.

Hi royUK,

I have tried the custom number format via the Format Cells option, the problem is the code actually removes the zeros before it is sent to the spreadsheet

Originally Posted by Kerno

Hi royUK,

I have tried the custom number format via the Format Cells option, the problem is the code actually removes the zeros before it is sent to the spreadsheet

Try adding the format in the code.

Hi jindon,

Thanks for the code, the problem is it does not increment to the next number whenever it finds an "A", "T" or P" in column A as in
A A0124
A A0125
T T0125
P P0126
P P0127

the reference cells will always be B3, B4 and B5 which is downloaded from a database, this is what is already in the database so I need the next incremented numbers created.

Hope this make sense

Hi royUK,

Could you please show me what you mean, I have tried a variety of formats but it seams to makes no difference.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks jindon works great