Thread: Add "accounting indent" to blank zero number format
View Single Post
 
Old 01-05-2022, 06:25 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
Question Add "accounting indent" to blank zero number format
Hi folks

Is there any way of adapting this number format:

Quote:
#,##0_);(#,##0)
...so that it hides zero values? I've been using:

Quote:
0;-0;;@
...but when it returns a value greater than "0" the alignment is too close to the right-hand cell border and the figures don't align correctly as there is no indent.

Can anyone help?

Thanks, Matt
Reply With Quote