I don't use Lotus, but I see your point.

Gordon wrote:

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

--

Dave Peterson