IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS

[BRAINOC]

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

 

[Gord Dibben]

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 Edit>Paste Special>Add>OK>Esc


Gord Dibben MS Excel MVP

 

[pshepard]

Hi Brainoc,

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

Thanks,
Peggy