View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Richard is offline
external usenet poster
 
Posts: 709
Default Why is Excel displaying the formula as text

nope. that wasnt it. strange.

"Dave F" wrote:

Perhaps there is an apostrophe to the left of the = sign.
--
Brevity is the soul of wit.


"Richard" wrote:

This isnt the situation where the formula versus value is being shown. This
is a situation where it thinks the formula is a text value.