C
Cheryl
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!
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!