ExcelBanter - Right align positive and neg numbers using brackets around neg #s

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Right align positive and neg numbers using brackets around neg #s (https://www.excelbanter.com/excel-worksheet-functions/246721-right-align-positive-neg-numbers-using-brackets-around-neg-s.html)

Terri

Right align positive and neg numbers using brackets around neg #s

How can I right align numbers in Excel but keep the right bracket of negative
numbers offset from the numbers?

Jacob Skaria

Right align positive and neg numbers using brackets around neg #s

Do you mean the below..

Custom format the cells to
0.00_);(0.00)" "

If this post helps click Yes
---------------
Jacob Skaria

"Terri" wrote:

How can I right align numbers in Excel but keep the right bracket of negative
numbers offset from the numbers?

All times are GMT +1. The time now is 06:10 PM.