-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Adding zero
- Thread starter ehsas69
- Start date
Quick and dirty solution really.
Insert an extra column and then use =A1&"000000" (where A1 is the original 6 digit number you have), copy the column, paste as values and delete the original column.
Not particularly sophisticated, but it works.
Insert an extra column and then use =A1&"000000" (where A1 is the original 6 digit number you have), copy the column, paste as values and delete the original column.
Not particularly sophisticated, but it works.
Last edited:
Upvote
0
