Series with HyperLink

[opazzo]

Hi All,

Here is my situation : i 've got a column A with sequential numbers like this

1
2
3
4


On each cell of this column there is an hyperlink to a file named with the same number

1 got an hyperlink to 1.pf
2 got an hyper link to 2.pdf and so on

I dont' want to do this one cell by one cell because i have more than a thousand to do.

How could I easily make a serie which will link the right file with the right cell number.

Thanks

 

[opazzo]

I double checked. My fault.

Everything works great !

Thank you so much.

I owe you a beer.

 

[GlennUK]

Thank goodness for that ... I was running out of ideas about what could be going wrong.

Glad it's all OK now.

Will have that beer any time