Number formatting
 

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

Number formatting
 

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





pm wrote:

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

Number formatting
 

Thanks Dave that worked.

"Dave Peterson" wrote:

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





pm wrote:

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