View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Formula vs. Constant

hi
you might consider the goto function.
press F5. click the special button bottom right.
check formula then ok. excel will high light all formulas.
you can do the same with constrants.

regards
FSt1

"rk0909" wrote:

Is there a way using excel funtions (not UDF) to find if a cell contains a
formula vs. a number (constant).
I looked around the forum but did not find anything. I tried using cell
function and left function but they return the value in the formula itself.
Any help is appreciated.
Regards,
RK