Forum Discussion
Solved
Auto cell formatting
Is it possible to format a number in a cell by number of decimal places, where the number of decimal places is stored in a different cell? I enter a load of data in rows into a tab ("data") that ...
Of course, you can set the number of descendants displayed with a reference to a cell. However, this also changes the value. It is not pure formatting.
For example: TRUNC():
=TRUNC(1.66,A1)
A1=1
Result = 1.6The same is true with ROUND() etc.
I hope this has helped you.
That works a treat for shortening numbers to a number of decimal places but doesn't add trailing zeroes on, even if I store the number with eg. 4 decimal places say 66.0000 and ask it to truncate to 1 dp it just gives me 66 not 66.0
I've tried formatting the cells as 'general' and as 'number' and it doesn't seem to work either way.
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.
- That might be it.
Thank you so much.
=value() will turn it back into a number when I need it to be.
