Thread: Adding a Zero
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Little Penny[_3_] Little Penny[_3_] is offline
external usenet poster
 
Posts: 48
Default Adding a Zero

I'm looking for a macro that will add a zero of the first character in
column starting in the row 2 (W2 to Last row with data).

Example:

This:

aaaaaaa
bbbbbb
cccccc

Would look like:

This

a0aaaaaa
b0bbbbb
c0ccccc



Little Penny