#1
|
||||
|
||||
Remove trailing zeros from number format but only for a zero value
Hi folks Is there any way of adjusting the number format below so that trailing zeros do not appear when the value is zero? Quote:
Many thanks. |
#2
|
|||
|
|||
You can do this manually. See photo: -
|
#3
|
|||
|
|||
Just realised your Office version is very old so my photo may not apply.
I also do not know how to automate the task. |
#4
|
||||
|
||||
Thanks. I do have that button but, yes, I want it to be automatic as I have a number of custom Styles set for whole areas of the spreadsheet and don't want to fiddle around with individual cell formatting.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Remove trailing spaces AND line breaks in a block of text | JulianS96 | Word | 4 | 02-04-2020 04:20 AM |
How to remove trailing & leading spaces in a cell? | LearnerExcel | Excel Programming | 8 | 02-04-2018 08:22 PM |
How to format a TOC (level 1) using a number, but have the number hidden in the text | porpoiseoil | Word | 1 | 09-13-2014 12:53 PM |
Heading's Footnote's number is displayed in TOC. How to remove the number in TOC? | Orehrepus | Word | 1 | 07-13-2014 12:51 PM |
Change from General Format to number format | gbaker | Excel | 3 | 08-16-2013 01:04 PM |