Excel sheet problems

N

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
 
J

JE McGimpsey

Try something like:

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

or

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

etc.
 
N

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
 
D

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
 
G

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
 
S

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")&"]"
 
Top