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

11-22-2021, 06:23 AM

wiganken

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

Office 2019

Expert

Join Date: Jul 2018

Posts: 279

You can do this manually. See photo: -

Attached Images

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:47 PM.