Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Access data into Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Import data question | Setting up and Configuration of Excel | |||
how do I import data from iSeries in Excel 2007? | Excel Discussion (Misc queries) | |||
Excel 2007/Vista: Missing file name on import external data connection | New Users to Excel | |||
Excel 2007 Data Import from txt files | Excel Discussion (Misc queries) |