need a formula

  • Thread starter Beckyw via OfficeKB.com
  • Start date
B

Beckyw via OfficeKB.com

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
 
D

Dave Peterson

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
 
B

Beckyw via OfficeKB.com

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
 
Top