Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 72
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
importing numbers into .csv file Gary Breakfield Excel Discussion (Misc queries) 1 January 25th 08 05:35 PM
Importing data numbers JB Excel Discussion (Misc queries) 4 January 10th 08 09:47 AM
Decimal Numbers typed into Excel 2003 read as whole numbers john mcmichael Excel Discussion (Misc queries) 1 May 10th 07 08:18 PM
Numbers read as text anandmr65 Excel Discussion (Misc queries) 5 February 1st 06 12:45 PM
How do I read tab numbers into formula? Gregg Excel Discussion (Misc queries) 2 June 7th 05 10:46 PM


All times are GMT +1. The time now is 03:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"