remove number formatting
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

Do you have the Decrease Decimal button?

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.

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.

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives