remove number formatting

Robin Herrick

How do you remove number formatting? Once you've applied a fixed number of decimal places, there doesn't seem to be any way to remove that formatting.

James Keuning

Do you have the Decrease Decimal button?

Robin Herrick

Yes I do have the button to decrease decimal places.

Before you apply number formatting, you will see 0, 0.5, 1, 1.5

Apply a decimal place and you will see 0.00, 0.50, 1.00, 1.50

Remove a decimal place: 0.0, 0.5, 1.0, 1.5

Remove another decimal place: 0, 1, 1, 2

There is no way to get back to the beginning formatting.

Robin Herrick

I think I found the solution. Click the thousands separator twice to apply and remove it. This seems to also clear the decimal place formatting. If you click it a third time, the decimal place formatting, which is lurking in the background, reappears. It's not ideal, but it's a workaround. If you add decimal places they do show; remove them and you are not left with trailing zeros.

Sam Swain

I encountered this problem. My % kept showing up as 1,4900 % instead of 49%

I used this formula to get the correct figure returning...

=ROUND(SUM( valueA / value b * 100), 0) + "%"

ROUND and ,0) reduces the value to 0 decimal points and then you add the text %. If you want it to one decimal point it would be:

=ROUND(SUM( valueA / value b * 100), 1) + "%" etc