Can you use autoformat to change the number of decimal places of a cell depending on the value of another cell?
For example:
Cell A1 is a number which needs to be to 3, 4 or 5 decimal places depending on the value of cell B1 as follows:
B1 value Number of decimal places that A1 needs to be
"T1" 3
"T5" 4
"T6" 5
I would have done this as a macro on start of sheet, but the value of B1 can change at any time.
Thanks for any help.
Bookmarks