Thread: Remove trailing zeros from number format but only for a zero value
View Single Post
 
Old 11-22-2021, 05:19 AM
Matt C's Avatar
Matt C Matt C is offline Windows 10 Office 97-2003
Advanced Beginner
  
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