Comma Style Formatting from Format Toolbar

T

Tony McGee

Hello all

I am using Excel 97 SR-2.

All of a sudden my Comma Style formatting button (from the formatting
toolbar) is formatting differently to previous and is not want I want.

My Control Panel settings for number and currency I have always set to
display negatives in brackets and this is how the Comma Style button used to
work.

Now it formats negatives with a leading negative sign with the sign aligned
to the extreme left of the cell with the numbers right aligned.

Any adeas on how I get this formatting button to work correctly again???

Thanks

Tony McGee
 
Top