How do I add a leading 0 to a group of cells
 

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?

How do I add a leading 0 to a group of cells
 

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.

"Fuzy Duk" wrote:

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?

How do I add a leading 0 to a group of cells
 

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?

How do I add a leading 0 to a group of cells
 

Awsome Dave! Thanks for saving my valuable time.

"DaveO" wrote:

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.

"Fuzy Duk" wrote:

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?

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?