Negative numbers
 

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

Negative numbers
 

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

General;(#,##0.00)

--
Rick (MVP - Excel)


"AJW30" wrote in message
...
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

Negative numbers
 

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

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
Perhaps this Custom Cell Format will do what you want...

General;(#,##0.00)

--
Rick (MVP - Excel)


"AJW30" wrote in message
...
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

Negative numbers
 

Hi,
format the cell with custom format and use

"-"0.0

"AJW30" wrote:

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

Negative numbers
 

"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

"AJW30" wrote in message
...
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

Negative numbers
 

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


On Wed, 24 Feb 2010 10:05:01 -0800, AJW30
wrote:

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