IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS
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
|