Remove trailing zeros from number format but only for a zero value

		Microsoft Office Forums > Microsoft Excel > Excel
Remove trailing zeros from number format but only for a zero value

FAQ

Thread Tools

Display Modes

11-22-2021, 05:19 AM

Matt C

Windows 10 Remove trailing zeros from number format but only for a zero value

Office 97-2003

Advanced Beginner

Join Date: May 2021

Location: London, UK

Posts: 30

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:

#,##0.00_);(#,##0.00)

In other words, if I type "35" then it'll return a value of "35.00" (which I want), but if I type "0" I want the value displayed as "0" rather than "0.00".

Many thanks.

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