Custom Number Format

[goss]

Hi all,

Using Excel 2010.

I would like a customer number format with a leading "+" for positive number and a leading "-" for negative numbers.

My string works for positive numbers + 200.00 but not negative numbers.
The negatives display as (200.00). I would prefer - 200.00.
Current display string:
"+"_(* #,##0.00_);_(* (#,##0.00);"-"_(* "-"??_);_(@_)

I tried copying the format for positive numbers into the display for negative values and changed the sign, but that still displayed as (200.00)

I tried some variations on the format string such as
"+"_(* #,##0.00_);_(* (#,##0.00);"-"_*#,##0.00_;_(@_)

But I received back an error message:
Microsoft Excel cannot use the number format you typed

Any thoughts on how I can get the display I would like?

 

[Expiry]

Try something simpler, like

"+"0;-0;

 

[MrKowz]

Custom Number formats are in the order:
Positive;Negative;Zero;Text

You have the negative sign associated with the Zero field.

Try:

"+"_(* #,##0.00_);"-"_(* (#,##0.00);_(* "-"??_);_(@_)

 

[goss]

Thanks Expiry and MrKowz,

Expiry,

I started with the accounting format with no leading $ sign, its just my preference.
I added the "+" in front. The end result aligns the plus to the left of the cell and the number to the right of the cell. This gives nice visual clarity to the end user as to itent for cr/db while using using one column rather than two.

MrKowz,

Thanks for pointing that out.
Here is my final format string, works great!
"+"_(* #,##0.00_);"-"_(* #,##0.00_);_(* "-"??_);_(@_)

 

[MrKowz]

Glad it works. Thanks for the feedback!