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