View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Hemant Hemant is offline
external usenet poster
 
Posts: 12
Default Why Excel creates hyper link in case of formula.

While executing a formula such as = L5 - @sum(O5:M5), a hyperlink is
created. However in case of a formula =L5 - O5 a simple figure is displayed.
Can anyone explain how to avoid excel from creating hyperlink.
Thanks.