I copy an paste a web page into sheet 1.

Sheet 2, cell A10 has the formula: ="Sheet1!A"&(RIGHT(A9,2)+3)
Because the values I need to work with end up in every third row after
pasting(actually the web page results in Excel merging 3 cells together).

Sheet 2, cell F10 has the formula: =INDIRECT(A10) and results in 09
appearing as the result in the cell.

Now I want to do calculations based on that value of 9, but no matter what I
do I get a #VALUE! Error. I've tried setting the cell format of each of the
relevant cells to number, I've tried using the VALUE function to convert F10
to a number, which also gives a VALUE! error. I'm stuck.

Any ideas appreciated.
ed