Format all to General.

Copy an empty cell.

Select the range of bogus numbers abd EditPaste SpecialAddOKEsc.


Gord Dibben MS Excel MVP

On Tue, 12 Feb 2008 21:45:01 -0800, keeno
wrote:

Please help this beginner! I export a Foxpro database to an Excel
spreadsheet. In a separate (job quote) spreadsheet I try to match a quote
number to it's corresonding row in the exported spreadsheet and fill in cells
in the quote sheet. What I get is #N/A. If I format the column in the
exported spreadsheet as either a number with no decimal places, or
General--the problem persists. But if I re-type the number (in the exported
spreadsheet) the number goes from left justified to right justified and now
the Vlookup formula in the quote sheet works. The exported spreadsheet grows
daily and I'd like to be able to find an automated way to use that data. Why
do I have to re-type the info?