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

IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS
 

Please drop the ALL CAPS.........hard on the ears and eyes.

Format all to General.

Select an empty cell and copy.

Select the range to change and EditPaste SpecialAddOKEsc


Gord Dibben MS Excel MVP

On Tue, 8 Jul 2008 11:16:49 -0700, 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

IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS
 

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