Excel's VALUE function has only one argument: where a is the value stored as text that you want to convert into a number.
You can freeze a row in Excel through the "Freeze Panes" menu. This lets you scroll through a spreadsheet without that frozen data leaving the screen.