Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Web Data to Excel
I am trying to copy data from a number of web pages. It all works fine until
I try to copy a cell that refers to where a an entrant came in the field. For example a person who came 8th of 8 entrants would have an entry of 8/8 in this cell. Excel automatically assume that 8/8 refers to the 8th day of August and returns it as a date field. I cannot input to the web page (only alter it once it is copied across to Excel) but cannot seem to do anything to convert it back to 8/8. I hope that someone can help me. Many thanks - Rod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying Web Data to Excel
Rod Bowyer wrote:
I am trying to copy data from a number of web pages. It all works fine until I try to copy a cell that refers to where a an entrant came in the field. For example a person who came 8th of 8 entrants would have an entry of 8/8 in this cell. Excel automatically assume that 8/8 refers to the 8th day of August and returns it as a date field. I cannot input to the web page (only alter it once it is copied across to Excel) but cannot seem to do anything to convert it back to 8/8. I hope that someone can help me. Many thanks - Rod Format the required cells as Text -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200707/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying data - Excel 2007 | Excel Worksheet Functions | |||
Copying Data from Access to Excel in a macro | Excel Worksheet Functions | |||
Stop excel from copying data from one sheet to another | New Users to Excel | |||
Copying Data From Internet to Excel | Excel Discussion (Misc queries) | |||
copying data from Excel spreadsheet to another | Excel Discussion (Misc queries) |