Excel sheet problems

[neilangelo]

I am having a problem in excel where it will not show negative figure
in brackets...even when I go to format cell, and number the option i
not there to choose brackets.

The excel package I am using is a part of Office 2000

 

[JE McGimpsey]

Try something like:

Format/Cells/Number/Custom #,##0_);(#,##0);0_);@

or

#,##0.00_);(#,##0.00);0.00_);@

etc.

 

[neilangelo]

I've tried the above solution, but I need it to work automaticall
without having to go to custom.

Previously, when i go to format/cells/number, the brackets wer
automatically there. Why are they no longer there

 

[Frank Kabel]

Hi
this depends on your regional Windows settings.

 

[Dave Peterson]

To add to Frank's reply:

There's a windows setting you can change:

The way I'd get to in Win98 is:

Windows Start button|settings|control panel|Regional Settings
Currency Tab|Negative Number Format

 

[Gord Dibben]

In Win XP it would be Start>Settings>Control Panel>Regional and Language
Options>Regional Options.

Select your language from the drop-down then hit "Customize" and "Currency"
tab.

Gord Dibben Excel MVP

 

[SidBord]

Actually I've never tried brackets, but go to the
FORMAT->CELLS and choose CUSTOM. Try creating your own new
format. I'm not saying it will work. The alternative is
to convert it to a text string. If the value is in cell
A1, then try: ="["&Text(A1,"0.00")&"]"