Well that seems to work for the straight up # with no decimals. (Thanks!)

Now my next problem is how to do this same thing but with a percentage with
3 decimal places.

"Satti Charvak" wrote:

can try this also:

+#;-#

just tilt you head to the left and check the answer.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast


"Ashish Mathur" wrote:

Hi,

Select the cells where you want to apply the formatting and then in Format
Cells Number Category Custom Type, enter the following:

"+"#,##0_);(#,##0)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Emil" wrote in message
...
I have a cell which fluctuates based on its formula between positives and
negatives. (I use Excel 2007 if that matters).

When the value is negative it always shows the "-". How can I make this
also show the "+" if the value is positive?

Thanks in Advance,
Emil