I have a column of numbers and a "totals" row at the bottom that contains
=sum(C4:C21). When I add a symbol it appears to not see the number.

"Mike H" wrote:

Hi,

Doing this as a format means the symbol is ignored when doing any
calculation on the cell so I don't understand what you mean by

It still subtracts the number in the total.

Perhaps you could give a fuller explanation of what your trying to do.

Mike

"judyl" wrote:

That didn't work :( It still subtracts the number in the total.

"Mike H" wrote:

Hi,

Do it with a format.

Right click your cell - Format - Number tab -select Custom
enter this custom format alter to include the symbol you wannt

0.0" Your Symbol"

OK

Mike

"judyl" wrote:

I'm trying to insert a symbol next to a number in a cell that is totaled.
When I attempt this the number is not then recognized for the correct total.
Do I need to change my SUM fx in some way to correct this?