I'm staying the hell out of this one<g

Don't wish to upset the other Gordon and his hundreds of colleagues.


Gord

On Thu, 17 Feb 2005 18:08:55 -0600, Dave Peterson
wrote:

Close excel

Change that windows regional setting|currency tab|Negative currency format
to show ($1.1)

Open excel

If you click on Format|cells|Number tab
then choose Number, do your formatting options include ()'s for negative
numbers.

They do for me.

Close excel

Change that windows regional setting|currency tab|Negative currency format
to show -$1.1

Open excel

If you click on Format|cells|Number tab
then choose Number, do your formatting options include ()'s for negative
numbers.

They do not for me.



Gordon wrote:

IanRoy wrote:
1234Hi all;

On my Windows XP Home:
Start Control Panel Regional and Language Options Regional Options
"English (United States) Customize
Numbers Negative number format: -1.1
Currency Negative currency format: ($1.1)
I switch to Excel 2003.
Enter -10 in a cell, it shows as -10. Change the format of that cell to
currency, it shows ($10.00).

In my version of Excel 2002, when you Format cells to currency, you have
to choose a format! Either -£ or (£) - there's no "generic" format for
currency. And an ordinary negative number, ie NOT currency STILL DOES
NOT USE THE REGIONAL SETTINGS! IT NEVER HAS!

--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk