ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I align ( ) in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/53400-how-do-i-align-excel.html)

jules

How do I align ( ) in excel?
 


Fred Smith

How do I align ( ) in excel?
 
The ending bracket will align nicely. Is it that you want to align these
negatives numbers in a column which also has positive numbers?

--
Regards,
Fred


"jules" wrote in message
...




[email protected]

How do I align ( ) in excel?
 
This is done through number formats
Use
0.00_);(0.00);0
The underscore character means leave a space the size of the following
character
The first part of format is positive numbers followed by negative followed
by zero followed by text


"Fred Smith" wrote:

The ending bracket will align nicely. Is it that you want to align these
negatives numbers in a column which also has positive numbers?

--
Regards,
Fred


"jules" wrote in message
...






All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com