Hi Louise

Either exit Excel, and go back in, or reformat the affected cells as
number/currency, an d re-enter the data

"Louise" wrote:

Hi

Really sorry about this but it doesn't seem to have worked??

I've put () in the negative section and the negative number format is now
(1.1). Any idea why it's not working??

Thank you.

Louise

"Kassie" wrote:

Hi Louise,

When you get to Currency, click on Customize, which is right next to
Language, and go doen the list to Negative Number Format (5th from the top,
4th from teh bottom)
"Louise" wrote:

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