JZB
04-30-2009, 01:49 AM
Hi guys
I have a list of data, some codes with numbers and letters e.g 25H and other just numbers e.g 25
I want to add a 0 at the front of the numbers only.
so real basic loop but how do i word the condition? i basically want to say
If activecell = number then
Activecell = "0"& activecell
End if
sorry, pretty basic stuff i know :dunno
I have a list of data, some codes with numbers and letters e.g 25H and other just numbers e.g 25
I want to add a 0 at the front of the numbers only.
so real basic loop but how do i word the condition? i basically want to say
If activecell = number then
Activecell = "0"& activecell
End if
sorry, pretty basic stuff i know :dunno