| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rs.10,250.00 formula Rupees ten thousand two hundred fifty only | New Users to Excel | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Conversion | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Linear Mode
