Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-22-2021, 05:19 AM
Matt C's Avatar
Matt C Matt C is offline Remove trailing zeros from number format but only for a zero value Windows 10 Remove trailing zeros from number format but only for a zero value Office 97-2003
Advanced Beginner
Remove trailing zeros from number format but only for a zero value
 
Join Date: May 2021
Location: London, UK
Posts: 30
Matt C is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-22-2021, 06:23 AM
wiganken wiganken is offline Remove trailing zeros from number format but only for a zero value Windows 10 Remove trailing zeros from number format but only for a zero value Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

You can do this manually. See photo: -
Attached Images
File Type: png Remove trailing zeroes.png (57.7 KB, 10 views)
Reply With Quote
  #3  
Old 11-22-2021, 06:25 AM
wiganken wiganken is offline Remove trailing zeros from number format but only for a zero value Windows 10 Remove trailing zeros from number format but only for a zero value Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Just realised your Office version is very old so my photo may not apply.

I also do not know how to automate the task.
Reply With Quote
  #4  
Old 11-22-2021, 06:46 AM
Matt C's Avatar
Matt C Matt C is offline Remove trailing zeros from number format but only for a zero value Windows 10 Remove trailing zeros from number format but only for a zero value Office 97-2003
Advanced Beginner
Remove trailing zeros from number format but only for a zero value
 
Join Date: May 2021
Location: London, UK
Posts: 30
Matt C is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove trailing zeros from number format but only for a zero value How to Remove trailing spaces AND line breaks in a block of text JulianS96 Word 4 02-04-2020 04:20 AM
Remove trailing zeros from number format but only for a zero value How to remove trailing & leading spaces in a cell? LearnerExcel Excel Programming 8 02-04-2018 08:22 PM
Remove trailing zeros from number format but only for a zero value 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
Remove trailing zeros from number format but only for a zero value 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 12:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft