View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Formula shows not results

Format the cell with the formula as general or number (not text), then
reenter the formula (or just press F2 and enter)


--
Regards,

Peo Sjoblom



"David" wrote in message
...
LOL

I have type a simple formula into a cell.

=SUM(A1:A13)

The formula appears after I press the enter button Check mark.... I press
the Fx and the results add up correctly.... yet the results do not appear
only the formula.

What have I done? Can I get the formula in the background and the results
to
appear?

--
David