Number formatting

pm · May 29, 2007

I have a column of numbers, for instance 1.21, that i need formatted to
decimal 9.6.

Any ideas?

Thanks.

Should look like 000000001210000

Dave Peterson · May 30, 2007

How about using a helper cell:
=TEXT(A1*10^6,REPT("0",15))

pm · May 30, 2007

Thanks Dave that worked.

Dave Peterson said:
How about using a helper cell:
=TEXT(A1*10^6,REPT("0",15))