Adding cells that are calculated with formula's

  • Thread starter Thread starter Chris
  • Start date Start date
C

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!!
 
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).
 
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
 
Back
Top