You don't even need that other column of numbers.
Put this in A1:
=hyperlink("http://example.com?id="&row())
Ken wrote:
Greetings,
there is a column is number, I want to add a hyperlink to the each
number.
for example,
item A, row 1 is number 1, after the adding the hyperlink to it which
displays 1 but I can click it and link to http://example.com?id=1.
and for row 2, the link will be http://example.com?id=2, and so on.
how to do this?
--
Dave Peterson