Change the number of decimal places

CWest

Is there a way to change the number of decimal places in a given cell based on a value from another cell.

Basically, we ask our customers to update how many decimal places they want a value to go out to and we need the cell value in specific columns to match what the customer would like. It would save a lot of time if I could automate this once the change is made in the sheet.

I tried using the =ROUND function but I got a circular reference error. See example below. The decimal is correct here but only because I manually manipulated it.

Carol West

bisaacs

Hey @CWest,

You'd need an extra column for the actual number to be entered, then you'd use ROUND on the columns you'd want the number w/ decimals to display on (so in your example, lets say for the AU680 only row, they entered 5.525 in your "helper" column, then you'd put the =ROUND([Analyti…Measu… Range - Low]@row, [Decimal Places]@row)).

You were getting a circular argument because you can't have a formula where one of the cells in the formula is the cell where the formula is located.

Hope this helps!

CWest

I was trying not to create helper rows as I have about 4 different low/high columns that I would have to do this with. But, if it is the only way, I can always hide the "old" value