Forum Discussion
Re: Auto cell formatting
Another possibility would be:
=TEXT(A1,"#,##0"&IF(B1=0,"","."&REPT("0",B1)))
A1=66
B1=5
Result=66.00000With the disadvantage that the number is then converted to a text. But maybe that doesn't bother you.
1 Reply
- That might be it.
Thank you so much.
=value() will turn it back into a number when I need it to be.
