ExcelBanter - Why Excel creates hyper link in case of formula.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Why Excel creates hyper link in case of formula. (https://www.excelbanter.com/excel-discussion-misc-queries/116806-why-excel-creates-hyper-link-case-formula.html)

Hemant

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.

Jim Cone

Why Excel creates hyper link in case of formula.

Don't use "@" in a formula.
= L5 - Sum(M5:O5) would work..
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Hemant"
wrote in message
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.

Hemant

Why Excel creates hyper link in case of formula.

Great Answer... Thanks.

"Jim Cone" wrote:

Don't use "@" in a formula.
= L5 - Sum(M5:O5) would work..
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware

"Hemant"
wrote in message
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.

All times are GMT +1. The time now is 04:20 PM.