Add "accounting indent" to blank zero number format

		Microsoft Office Forums > Microsoft Excel > Excel
Add "accounting indent" to blank zero number format

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-05-2022, 06:25 AM

Matt C

Windows 10 Add "accounting indent" to blank zero number format

Office 97-2003

Advanced Beginner

Join Date: May 2021

Location: London, UK

Posts: 30

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:38 AM.