ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   format cells that will show the data in parenthesis (https://www.excelbanter.com/excel-discussion-misc-queries/257788-format-cells-will-show-data-parenthesis.html)

Hoop

format cells that will show the data in parenthesis
 
I would like to format some cells that I put data into to be in ( )
Parentesis.. How do I do this?

Fred Smith[_4_]

format cells that will show the data in parenthesis
 
An example would have been very useful. Assuming it's negative numbers you
want to parenthesize, use a custom format of:
#,##0.00;(#,##0.00)

Regards,
Fred

"Hoop" wrote in message
...
I would like to format some cells that I put data into to be in ( )
Parentesis.. How do I do this?




All times are GMT +1. The time now is 05:51 PM.

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