negative numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 28 Aug 2007 01:40 GMT

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.

Reply to this Message

Dave Peterson - 28 Aug 2007 02:46 GMT

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.

> 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.

Signature

Dave Peterson

Reply to this Message

Bob - 28 Aug 2007 03:04 GMT

Thank You Dave. Problem is solved

> Excel picks this up from a windows setting:
>
[quoted text clipped - 10 lines]
> > is. Both are running OFFICE 2003 PRO. I have not checked this on any other
> > machines in the office.

Reply to this Message