Add "accounting indent" to blank zero number format

Matt C · #1 01-05-2022, 06:25 AM

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

xor · #2 01-07-2022, 01:05 AM

#,##0_);(#,##0);

Matt C · #3 01-07-2022, 07:26 AM

Thank you - much appreciated.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula to format "I" column based on if "F" column row is not blank	ravl13	Excel	3	08-22-2017 12:26 PM
Number in customized, numberer "Heading 2" format obscured by black background	drhansenjr	Word	1	08-10-2017 12:43 PM
Weird "new/blank document" format in Word 2007	bjones	Word	2	06-07-2014 06:45 AM
Paste data in "Accounting"format from Excel into Word changes formatting	cory_0101	Word	4	10-17-2012 12:30 PM
Is there a way to make the cross-refernce format to be "Only lable and number"?	Jamal NUMAN	Word	1	04-10-2011 03:31 PM