to add a hyperlink formula in excel:
=HYPERLINK("#sheetname!"&CELL("address",A999))
where 'sheetname' is the name of the worksheet and
'A999' is the the cell to link to
the pound sign, # is _Necessary_
My random tech problems and chicken scratching for notes on what I did to solve them.
server$ set -o | grep ignoreeof
ignoreeof on
server$ set +o ignoreeof
server$ set -o | grep ignoreeof
ignoreeof off
server$ hit cntl-D
logout
It might be helpful if a bunch of us complained about this missing key on the iPhone and iPod touch keyboards - leave feedback about the missing backtick/grave accent character at: http://www.apple.com/feedback/iphone.html
Really stupid for them to have it on the email address fields even though it's an invalid char for email addresses.