Help with hyperlink

[AlisonB]

Hi,

Someone else posted a topic a while ago that is similiar to something I
would like to do - but not quite! (Topic is now close by a moderator
as it was in 2004).

The original post was -

" Is it there a formula, that if you click on a Cell, you automatically
go to another Cell in that worksheet? (without using a macro?)

And the reply suggested using -

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

I have tried this and can see how this works, but the cell the formula
is in shows an underlined zero. How can I change the formula to give
me an asterix instead of an underlined zero?

Kind regards,

Alison

 

[Norman Jones]

Hi Alison,

How can I change the formula to give me an asterix instead of
an underlined zero?

Try:

=HYPERLINK("#"&CELL("address",C5),"*")

 

[AlisonB]

That works perfectly!

Thank you.

Kind regards,

Alison