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.
They do. That's NOT the point I was making. the point I was making, is
that in Lotus, if Regional Settings are set to (1.1), then when you
enter -1.1 in a cell, it is AUTOMATICALLY formatted to (1.1) - you don't
have to DO anything!
--
Interim Systems and Management Accounting
Gordon Burgess-Parker
Director
www.gbpcomputing.co.uk