Re: Convert Text to Numbers Problem
From: JE McGimpsey (jemcgimpsey_at_mvps.org)
Date: 03/23/04
- Next message: JE McGimpsey: "Re: saved"
- Previous message: Jack: "Multiple icons in taskbar"
- In reply to: Cheryl: "Convert Text to Numbers Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Mar 2004 09:26:09 -0700
The site may be using non-breaking spaces, which TRIM() will not remove.
Take a look at David McRitchie's TrimAll() macro:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
In article <186e01c410f0$b31108d0$7d02280a@phx.gbl>,
"Cheryl" <anonymous@discussions.microsoft.com> wrote:
> 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!
- Next message: JE McGimpsey: "Re: saved"
- Previous message: Jack: "Multiple icons in taskbar"
- In reply to: Cheryl: "Convert Text to Numbers Problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
