Number format using formula or cell content

M

mike hutchins

Is it possible to use a formula or the content of another cell to set
the number of decimal places? For example, if cell A1 had a formula
which results in the value 4, I want cell C6 to show 0.0000 and if
A1's value was 7 I want C6 to show 0.0000000.
Thanks....
 
M

MikeH

Hi dcronje,

Are you sure? I only see an ability to format the font, border or pattern.
Can you clarify or explain?
 
D

Dave Peterson

you could use a helper cell:

=text(c6,"0."&rept("0",a1))



But it'll be text--but just use the value in C6 if further calculations are
required.
 
Top