Hi Brainoc,

Or you can multiply numbers by 1 to change the field from text numbers to
numeric numbers.

Thanks,
Peggy

"BRAINOC" wrote:

WHEN COPYING DATA FROM A SPREADSHEET EMAILED TO ME AND PASTING THAT SAME DATA
INTO A DATABASE IN A MASTER SPREADSHEET THAT USES A V LOOKUP FUNCTION TO FIND
DATA EASILY, OFTEN THE FUNCTION DOES NOT WORK UNTIL THE TARGET NUMBER (A
PURCHASE ORDER #) IS RETYPED - WHICH DEFEATS THE ENTIRE PURPOSE

IT'S NOT A RANGE ISSUE - IT SEEMS AS IF IT NOT READING THE NUMBERS IN THE
COLUMN AS NUMBERS

HAVE ALSO NOTED THE SAME ISSUE WHEN WORKING WITH OUR PAYROLL DEPT - THEY
OFTEN CANNOT TOTAL COLUMNS OF NUMBERS CORRECTLY UNTIL THE NUMBERS ARE RE-TYPED