ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel, turn off the hyperlink format when formula is @sum (https://www.excelbanter.com/excel-worksheet-functions/55195-excel-turn-off-hyperlink-format-when-formula-%40sum.html)

babalouie

Excel, turn off the hyperlink format when formula is @sum
 
I am sure someone, somewhere can use the function, I absolutely hate it.

Can anyone assist me in turning off the hyperlink style format that appears
when an @sum formula is added to a spreadsheet in excel???



Tom Ogilvy

Excel, turn off the hyperlink format when formula is @sum
 
@sum is how it is done in Lotus 1-2-3. Just use sum with is the Excel
version.

=sum(A1:A10)

--
Regards,
Tom Ogilvy


"babalouie" wrote in message
...
I am sure someone, somewhere can use the function, I absolutely hate it.

Can anyone assist me in turning off the hyperlink style format that

appears
when an @sum formula is added to a spreadsheet in excel???






All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com