Sorry about the mix up with my previous posting.

To put negative amounts in brackets do the following:

Hightlight the cell your working in.
Format
Cells
Custom
Type the following in the space at the top: 0.00_);(0.00)

You will now be able to show negative amounts in brackets in that cell only.

Regards

Jeff Beecham Colchester






"Frustrated of Great Yarmouth" wrote:

I have tried the regional custom settings but the "apply" section is shaded
and inoperative. However the settings show negative numbers in brackets but
when I go to Excel all it does is show minus signs !! It is so terribly
frustrating.