how do i import data from a web page into excel 2007?
 

i need to import data from a web page into exceo 2007. some of the numbers
are 19 digits long and when they import excel changes them to a binary
number. i have formated the entire workbook to text and number and it still
does the same thing. am i miising a setting or somethig? when i choose paste
speical it keeps my number but it puts all the info into one cell and its
supposed to be in a chart form like it is on my web page. any help is greatly
appericated.

how do i import data from a web page into excel 2007?
 

Can't you just format those cells as text?
http://www.ozgrid.com/forum/showthread.php?t=42678

But Excel may still display ONLY the first 15 digits. I'm not sure how 2007
works; still hanging on to my 2003.


HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Stephen M" wrote:

i need to import data from a web page into exceo 2007. some of the numbers
are 19 digits long and when they import excel changes them to a binary
number. i have formated the entire workbook to text and number and it still
does the same thing. am i miising a setting or somethig? when i choose paste
speical it keeps my number but it puts all the info into one cell and its
supposed to be in a chart form like it is on my web page. any help is greatly
appericated.