Number format within a text formula
Hello,
I’m trying to put numbers from cell references into a formula, which itself is simple, but how do I format those numbers once there?
i.e. I would like to say ‘±1% tolerance for 100°C = ±1.00°C’
but I get ‘±0.01 tolerance for 100°C = ±1°C
I would always like to show 2 decimal places, even if it is .00
I would also like to show the ±0.01 as 1%
=”±”&B3&” tolerance of “&A3&”°C” &” = ±”&A3*B3&”°C”
John
Hello,I’m trying to put numbers from cell references into a formula, which itself is simple, but how do I format those numbers once there?i.e. I would like to say ‘±1% tolerance for 100°C = ±1.00°C’but I get ‘±0.01 tolerance for 100°C = ±1°CI would always like to show 2 decimal places, even if it is .00I would also like to show the ±0.01 as 1%=”±”&B3&” tolerance of “&A3&”°C” &” = ±”&A3*B3&”°C”John Read More