adding + sign to number column ?

[tcurrier]

I have a column of numbers that has a negative sign prefixing the negative numbers, but no plus (+) prefixing the positive numbers.
I need to add the (+) in order to conditionally match another column of number that does have the (+). Currently, it's flagging them as differences.

Can anyone help ?

 

[VN]

At file menu Format/Cells - Number -Custom
at Type :
Define

+#;-#

 

[tcurrier]

Thanks, that worked for the numbers other than 0. It replaced
all of the 0's with + with no 0 after it...

Is there any way to fix that ?

old:
0

new:
+

 

[VN]

Try

+#;-#;0

 

[Richard Schollar]

Hi

In case you're running into situations where rounding is coming into play you may want to use:

+0;-0;0

If you want decimals and comma separators for thousands, extend to:

+#,##0.00;-#,##0.00;0

for example.

Richard

 

[tcurrier]

OK, thanks.... but now I have another problem ......

Cell AJ10 has +299 (format +#;-#;0)

Cell AP10 has +299 (format +#;-#;0)

For my conditional formatting, I have:

if cell AJ10 value is not equal to cell AP10 value , then color the background of AJ10 to yellow.

if cell AP10 value is not equal to cell AJ10 value, then color the background of AP10 to yellow.

Both cells are yellow, even though the values are equal....

Any ideas ? Thanks....

 

[BatmanUK]

Are they actually the same, or do they just appear the same when displayed without decimal places?

Try changing the conditional formatting formula to

=ROUND(AJ10,0)<>ROUND(AP10,0)

Hope this helps.

 

[tcurrier]

There's supposedly no decimal places in the field, but when I use your formula, it works fine now !

Thanks a million !