Positive / Negative numbers (with brackets) align right

mattf731

New Member
Joined
Oct 25, 2017
Messages
4
Hi,

I currently have a listing of positive and negative numbers (ranging from numbers in the tens to hundreds to thousands to millions) and am looking to have all numbers aligned right excluding the ending ")" for all negative numbers. In other words, would like the alignment of all numbers and commas separating the larger numbers to match as you scroll down the listing.

I currently have all cells Aligned Right, but it seems that no matter how I format the cells, I'm unable to get an extra space at the end of the positive numbers to align with the negative numbers. I've tried #,##0_ );;(##,##0), but this doesn't seem to be adding the space at the end of the positive numbers as I expected it to.

Any help would really be appreciated.
Thanks!
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,500
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
You've missed out the negative formatting part of that custom format. It should be:

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

depending on how you want zero values displayed.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,787
Messages
5,524,875
Members
409,608
Latest member
GigaPat

This Week's Hot Topics

Top