ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why do I not have an option to bracket negative values? (https://www.excelbanter.com/excel-discussion-misc-queries/197885-why-do-i-not-have-option-bracket-negative-values.html)

PG Palmer

Why do I not have an option to bracket negative values?
 


Fred Smith[_4_]

Why do I not have an option to bracket negative values?
 
Beats us. It's there in everyone else's version of Excel. Have you tried to
format the cell?

Regards,
Fred.

"PG Palmer" <PG wrote in message
...



Dave Peterson

Why do I not have an option to bracket negative values?
 
You could change the format of the cell, but if you want the ()'s to show up for
negative numbers in the format|cells|number tab, you'll have to change a windows
setting.

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.

PG Palmer wrote:

--

Dave Peterson


All times are GMT +1. The time now is 05:59 AM.

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