Hi,

I downloaded an excel spreadsheet from a website. Column A:B on the
spreadsheet is a reference for my vlookup formula in another worksheet.

The cell where my formula returns #N/A.

Say Column A5 reflects 2000.01

If I go to the specific cell (A5) and "manually type" the exact information
on the same cell (2000.01) then my formula will work!

After typing manually and my formula works referring to A5 I tried use
Column A5 as a base and use Format painter for the rest of Column A but all
the rows in column A does not work for my formula unless I type manually each
information on the cells in column A.

Please help.