How do I add a leading 0 to a group of cells
That works great. Thanks, Andy!
"Andy" wrote:
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.
"Fuzy Duk" wrote in message
...
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?
|