ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   negative numbers (https://www.excelbanter.com/setting-up-configuration-excel/156037-negative-numbers.html)

Bob

negative numbers
 
When using EXCEL on one computer at work we can format negative currency
numbers to have brackets around them and show in red, while on another
machine the brackets are not available. Does anyone have any idea why this
is. Both are running OFFICE 2003 PRO. I have not checked this on any other
machines in the office.

Dave Peterson

negative numbers
 
Excel picks this up from 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.

Bob wrote:

When using EXCEL on one computer at work we can format negative currency
numbers to have brackets around them and show in red, while on another
machine the brackets are not available. Does anyone have any idea why this
is. Both are running OFFICE 2003 PRO. I have not checked this on any other
machines in the office.


--

Dave Peterson

Bob

negative numbers
 
Thank You Dave. Problem is solved

"Dave Peterson" wrote:

Excel picks this up from 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.

Bob wrote:

When using EXCEL on one computer at work we can format negative currency
numbers to have brackets around them and show in red, while on another
machine the brackets are not available. Does anyone have any idea why this
is. Both are running OFFICE 2003 PRO. I have not checked this on any other
machines in the office.


--

Dave Peterson



All times are GMT +1. The time now is 04:43 PM.

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