Adding cells that are calculated with formula's

[Chris]

I have calculated (using formula's) several numbers and I
can't seem to add them together.
I have tried changing the format of the cell to be
recognized as a number but still when I try to add the
number excel thinks they are text and will not add them.

Help!!

 

[steve]

Chris,

Need more input from you.

Are you calculating in code or on the worksheet?
If you are using code - what does it look like?

Repost with a copy of your code (in the post).

 

[Jerry W. Lewis]

Format changes the display, not the value itself. If the "numbers" you
are trying to add are text, they will remain text regardless of format.
Binary operators like +-*/ will coerce text into numbers where
possible, but functions like SUM() will not. Alternately, you can copy
a numeric zero, select the cells containing text "numbers" and
Edit|Paste Special|Add to convert to numbers.

Beyond these generalities, we will need more information from you before
we can provide specific answers.

Jerry