View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Caseybay
 
Posts: n/a
Default Why does formula show rather than results (not in text format)

I'm using the sum function to add 6 numbers in excel. In one particular
target cell, it refuses to print the answer; instead it prints the formula. I
have made sure that each of the 6 numbers and the target cell are formatted
"number", not "text".