Thread: visible formula
View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default visible formula

Casey

This usually indicates that the cell was pre-formatted as Text.

Re-format to General then hit F2 and ENTER to see results.


Gord Dibben Excel MVP

On Mon, 24 Oct 2005 12:53:04 -0700, "Caseybay"
wrote:

In my worksheet, I have to total several groups of numbers. I select the sum
function icon and highlight the field. All worked fine except one, which
instead of printing the answer, printed the formula (=SUM H51:H54). I can see
where the cell is formatted any differently than the others.