F
Fuzy Duk
I have a column with 934 lines in it and need to add a leading zero to each
line. How do I do this without adding line by line?
line. How do I do this without adding line by line?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
DaveO
In cell B1 use this formula ...
="0" & A1
Copy and paste this all the way down your data and it'll do as you ask.
HTH.
="0" & A1
Copy and paste this all the way down your data and it'll do as you ask.
HTH.
G
Guest
Hi
One way is to use a helper column like this:
="0"&A2
and fill it down. Once you are happy, copy the whole column of results, then
Edit/Past Special/Values to fix them in place.
Hope this helps.
Andy.
One way is to use a helper column like this:
="0"&A2
and fill it down. Once you are happy, copy the whole column of results, then
Edit/Past Special/Values to fix them in place.
Hope this helps.
Andy.
F
Fuzy Duk
Awsome Dave! Thanks for saving my valuable time.
DaveO said:In cell B1 use this formula ...
="0" & A1
Copy and paste this all the way down your data and it'll do as you ask.
HTH.
F
Fuzy Duk
That works great. Thanks, Andy!
Andy said:Hi
One way is to use a helper column like this:
="0"&A2
and fill it down. Once you are happy, copy the whole column of results, then
Edit/Past Special/Values to fix them in place.
Hope this helps.
Andy.