remove number formatting

Options

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.

Answers

  • James Keuning
    James Keuning ✭✭✭✭✭
    Options

    Do you have the Decrease Decimal button?


  • Robin Herrick
    Options

    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
    Robin Herrick ✭✭✭
    edited 06/03/22
    Options

    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
    Sam Swain ✭✭✭✭
    Options

    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