I need a formula that you can take a colum and change it so that i can add 7
zero's to the end of the numbers already there. thanks

Are those values in that other cell?

If yes, then maybe:
=A1*10^7
or
=A1*10000000
and drag down

If it's text:
=A1&"0000000"
and drag down.

(did you mean the right side?)

But it also depends on what's in that cell.
3.3333333333333
would break my first couple of formulas

"Beckyw via OfficeKB.com" wrote:

I need a formula that you can take a colum and change it so that i can add 7
zero's to the end of the numbers already there. thanks

--

Dave Peterson

what i have is 345236544 in a cell and i need to add 7 zeros to that and do
the same for the rest of the colum. So it should then be 3452365440000000
thanks for your help

Dave Peterson wrote:
Are those values in that other cell?

If yes, then maybe:
=A1*10^7
or
=A1*10000000
and drag down

If it's text:
=A1&"0000000"
and drag down.

(did you mean the right side?)

But it also depends on what's in that cell.
3.3333333333333
would break my first couple of formulas

I need a formula that you can take a colum and change it so that i can add 7
zero's to the end of the numbers already there. thanks

Hi Becky

Try
=TEXT(A1)&"0000000"

Regards

Roger Govier


Beckyw via OfficeKB.com wrote:
what i have is 345236544 in a cell and i need to add 7 zeros to that and do
the same for the rest of the colum. So it should then be 3452365440000000
thanks for your help

Dave Peterson wrote:

Are those values in that other cell?

If yes, then maybe:
=A1*10^7
or
=A1*10000000
and drag down

If it's text:
=A1&"0000000"
and drag down.

(did you mean the right side?)

But it also depends on what's in that cell.
3.3333333333333
would break my first couple of formulas


I need a formula that you can take a colum and change it so that i can add 7
zero's to the end of the numbers already there. thanks