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 I am getting formula displayed in some cells rather than the resul

Try this,

Sounds like they may be formatted as TEXT
Select the offending cell and format as general.
Tap F2
Tap enter

Mike

"GG" wrote:

For random individual cells within one worksheet. I can't find where you
tell at the individual cell level to display formula or result.

V. annoying.

Thanks in advance.
--
GG