Custom format:

+#.#;-#.#
OR
+#.##;-#.##


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

".Net Sports" wrote in message
...
On Oct 2, 7:43 am, "RagDyeR" wrote:
=A1+A2+A3

--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

Thanks for the responses.... the problem I have is, I need to add
these numbers in this column just like they are and have +9.5 as the
result (i'm using Office2003 version) and it won't let me autosum it
even when i remove the plus signs on the positive numbers, it just
spits out an "=sum()" where the +3 cell is.... I need to add these
like they are positive and negative numbers; how do I go into Format
Cells to do this????

".Net Sports" wrote in message

...
I have a column of numbers that i need to have a positive or negative
indicator to add up with the AutoSum function,

+3
-3.5
+10

...but can't get the autosum function on the row below to
calculate...i get an empty " =sum( ) " display; what is the correct
way to format these numbers so i can get the total of +9.5 with this
column