View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?