Thanks Hans, but I want the text to show up in the cell.

"Hans Knudsen" wrote:

Not quite sure if this is what you are after, but you might want to try:
=550+N("+late fee")
Only 550 will show up i the cell and you will be able to sum. =550+N("+late fee") will appear in the formula field.

Regards
Hans Knudsen



"Mango" skrev i en meddelelse ...
Hello-
I'm trying to sum columns that contain mostly number values, but that also
contain some occasional text. Excel, of course, ignores those cells that
contain text. I've noticed other users with similar questions, but I'm still
not getting it. The text does not have any quantitative value. It is merely a
visual tag that I want to print along with the number value. Is there a way
to make Excel ignore the text but still add the data? Perhaps a formula for
each cell that contains text + data that makes the SUM formula "see" only the
data for that cell? Please dumb it down for me, I'm new to Excel. Thanks.