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