Excel formulas
Excel formulas
(OP)
When including an excel function ( say the exponent e ^ (argument) ) in a cell expression, the cell contents has this annoying feature "mailto:.....", which takes you direct to outlook mail express when clicking on the cell.
Is it possible to disable this feature and leave it as a plain math expression ?
Is it possible to disable this feature and leave it as a plain math expression ?
RE: Excel formulas
https://www.msoutlook.info/question/excel-stop-tur...
RE: Excel formulas
On my version of Excel, the autocorrect function is in the Tools Tab - Options. Following the procedure suggested in the page you sent didnt work when I deselected the required checkbox. When I typed in "disable autocorrect hyperlink", and followed the suggested procedure, it worked, the mailto: disappeared.
Thanks a heap for this
RE: Excel formulas
RE: Excel formulas
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Excel formulas
This annoying feature was not there in earlier editions of Excel.
RE: Excel formulas
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Excel formulas
I called up a new blank sheet now and typed in an @exp() function in one cell and an @ln() in another, and this hyperlink feature hasn't popped up in either. In this new sheet I have deselected the hyperlink checkbox under Tools-AutoCorrect Options. All good now, so I dont have to clear out the hyperlink individually. Thats a relief.
RE: Excel formulas
https://documentation.help/MS-Office-Excel-2003/xl...
https://support.microsoft.com/en-us/office/implici...
RE: Excel formulas
Correction: The path to disable this feature in Excel is Tools - AutoCorrect Options - AutoFormat as you Type.
Once deselected, Excel applies this deselection to all new workbooks.