Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing numbers into .csv file | Excel Discussion (Misc queries) | |||
Importing data numbers | Excel Discussion (Misc queries) | |||
Decimal Numbers typed into Excel 2003 read as whole numbers | Excel Discussion (Misc queries) | |||
Numbers read as text | Excel Discussion (Misc queries) | |||
How do I read tab numbers into formula? | Excel Discussion (Misc queries) |