Convert Text to Numbers Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Cheryl (anonymous_at_discussions.microsoft.com)
Date: 03/23/04 

Date: Tue, 23 Mar 2004 08:05:45 -0800

I am trying to copy a table of data from a web page and
paste it into Excel. When I paste the information, some
of the numbers are treated as text, rather than numbers.
I have tried every method listed in the following article:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;181298 None of them work, aside from the Retype the
Values method. This is not practical for our
application.

I have tried changing the format of the numbers when the
web page is generated. This did not make a difference.
It appears that things that were integers in the database
that feeds the web page are recognized as numbers, while
those stored as single are recognized as text. I
converted the singles to ints and it made no difference.

Have I missed something? Any suggestions of other things
to try? Thanks!

Relevant Pages

  • RE: Importing data from excel spreadsheets
    ... it spits back a formatted sheet ... The format of the ... their own copy of the database, and get a piece of the formatted spreadsheet, ... Access and Excel are two different animals. ...
    (microsoft.public.access.externaldata)
  • Imported value from Access database changes when displayed in Excel
    ... another database. ... (I know, this is the Excel NG, but this question will ... to just dump the Recordset into the worksheet. ... So is this an Excel XP date format problem. ...
    (microsoft.public.excel.programming)
  • Questions on data exporting
    ... The database is a FF 1.57 relational database, ... export all data to a specific format (e.g. Excel, ... A Cust. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: DAO or ADO
    ... Load a ListBox from a Named Range in Excel using DAO ... is mdb the best database format to use in this case? ... what method should I use for calling up the database from ...
    (microsoft.public.word.vba.general)
  • Re: Time convert
    ... I use a multitude of SQL queries to get it to the format I desire, ... I open the excel sheet, I only get the date displayed but the time is ... Is there a way to query my Access database in such a way I only have ... it will have date and time in the field (since it is a date/time ...
    (comp.lang.basic.visual.database)