Hi Dave

Thanks for your reply. I have gone into the Regional Settings, however, on
the Currency tab I don't have an option for Negative numbers, it simply says
Number, Currency and Date??

Thanks.

Louise

"Dave Peterson" wrote:

Can your colleague use a built in format?

Format|Cells|number tab
Number category

There are options how to show negative numbers (red/with a minus/inside
parentheses).

If you don't see the parentheses option, you/your colleague can toggle a windows
setting.

Windows start button|settings|control panel|regional settings
(Or regional and language settings in winXP)

Regional Options tab, customize button in winxp

Currency Tab
change the negative currency format to show ()'s.

Louise wrote:

Good afternoon all

I have a colleague who is extremely new to Excel and when he types a
negative value into a cell, he wants it to show brackets rather than the
minus sign. I realise this can be done by applying a Custom Number Format,
however, as he is a complete beginner with Excel, I have a feeling this will
be too confusing for him.

Is there another way that he can apply this formatting rather than setting
up a custom number format?

Thank you.

Louise

--

Dave Peterson