a cell in excel will not display the formula total

[John]

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?

 

[Mike H]

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

 

[Spiky]

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

Or if P129 and P189 are Text instead of Values.