Adding + in front of a number
 

I have a column of numbers which represent a change in value over the
previous year. I want to have a + in front of the number if it's a positive
change.
Let's say my first number is 500.

My problem is that I can write something like, if(a10,"+"&a1), but when
then I can't format the number.

If the number is in the millions I can't provide a comma as a thousand
separator and I cannot tell it how many decimal places I want to show. Is
there a really easy way to do that, or do I have to write a huge formula to
precisely spell out the formatting within the formula?

Hi
try a custom format such as:
+0.00;-0.00;0.00

--
Regards
Frank Kabel
Frankfurt, Germany
"Ted Metro" schrieb im Newsbeitrag
...
I have a column of numbers which represent a change in value over the
previous year. I want to have a + in front of the number if it's a
positive
change.
Let's say my first number is 500.

My problem is that I can write something like, if(a10,"+"&a1), but when
then I can't format the number.

If the number is in the millions I can't provide a comma as a thousand
separator and I cannot tell it how many decimal places I want to show. Is
there a really easy way to do that, or do I have to write a huge formula
to
precisely spell out the formatting within the formula?

Custom format your cells as:

+#,##0;-#,##0;0;@

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column of numbers which represent a change in
value over the
previous year. I want to have a + in front of the
number if it's a positive
change.
Let's say my first number is 500.

My problem is that I can write something like, if
(a10,"+"&a1), but when
then I can't format the number.

If the number is in the millions I can't provide a comma
as a thousand
separator and I cannot tell it how many decimal places I
want to show. Is
there a really easy way to do that, or do I have to
write a huge formula to
precisely spell out the formatting within the formula?
.

you guys rule. Thanks Jason!!!

Thanks Frank!!




"Jason Morin" wrote:

Custom format your cells as:

+#,##0;-#,##0;0;@

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a column of numbers which represent a change in
value over the
previous year. I want to have a + in front of the
number if it's a positive
change.
Let's say my first number is 500.

My problem is that I can write something like, if
(a10,"+"&a1), but when
then I can't format the number.

If the number is in the millions I can't provide a comma
as a thousand
separator and I cannot tell it how many decimal places I
want to show. Is
there a really easy way to do that, or do I have to
write a huge formula to
precisely spell out the formatting within the formula?
.