a cell in excel will not display the formula total
 

my formula is P190 = sum(P129+P189)...P129 and P189 have money entries. P190
just keeps displaying a $ sign but no number totals. What am I doing wront?

a cell in excel will not display the formula total
 

John,

= sum(P129,P189) will work you don't need the plus but equally that won't
cause your problem either. Do you have formatting on the cell? if so delete
it and try again.

A Custom format of $ would give the symptoms you describe.

Mike

"John" wrote:

my formula is P190 = sum(P129+P189)...P129 and P189 have money entries. P190
just keeps displaying a $ sign but no number totals. What am I doing wront?

a cell in excel will not display the formula total
 

On Jun 14, 2:35 pm, Mike H wrote:
John,

= sum(P129,P189) will work you don't need the plus but equally that won't
cause your problem either. Do you have formatting on the cell? if so delete
it and try again.

A Custom format of $ would give the symptoms you describe.

Mike

"John" wrote:
my formula is P190 = sum(P129+P189)...P129 and P189 have money entries. P190
just keeps displaying a $ sign but no number totals. What am I doing wront?

Or if P129 and P189 are Text instead of Values.