Negative numbers

[AJW30]

Having chosen the ( ) format for negative numbers via the Regional/Keyboard
options in the Control panel, this still does not show as an option in the
normal list of number formats. Negative numbers on a spreadsheet just appear
with a minus sign. Any reason? I have tried the Conditional Formatting but
the end result is a number appearing as -(x,xxx.xx). I don't wish to see the
minus sign. I'm using Excel in Office 2007 with Windows 7

 

[Rick Rothstein]

Perhaps this Custom Cell Format will do what you want...

General;(#,##0.00)

 

[Rick Rothstein]

Actually, that should have been the following (to keep the same numerical
format for positive and negative values)...

#,##0.00;(#,##0.00)

and this if you want 0 to be shown as 0.00 instead of just 0 as well...

#,##0.00;(#,##0.00);0.00

 

[Eduardo]

Hi,
format the cell with custom format and use

"-"0.0

 

[Fred Smith]

"Any reason?": That's just the way Excel is. It looks at some Regional
settings, but not all.

There's no need to use Conditional Formatting. Just specify a custom format
like: #,##0.00;(#,##0.00)

Regards,
Fred

 

[Gord Dibben]

You must go back into Regional Options and set "Currency" negatives to () in
order to have the () as an available format in Excel.


Gord Dibben MS Excel MVP