Home |
Search |
Today's Posts |
#1
|
|||
|
|||
a problem with pasting into Excell sheet
I often need to paste into Excell sheet a table from Internet pages. Here
comes a problem: a cell, which on a web page looks like that: "8-5" after pasting looks like that: "08-may". I have formatted the cells before and after pasting, but the result was unsatisfactory. When I format beforehand - there is no difference. When I format after - in this cell apperas a 5-digit number. Can somebody help to solve the problem? Best regards Jurek. |
#2
|
|||
|
|||
Can you paste into NotePad?
The save that file as a *.txt file? Then you can use File|open and specify what each field should be. (Then copy|paste that imported data to its final home.) Jurek wrote: I often need to paste into Excell sheet a table from Internet pages. Here comes a problem: a cell, which on a web page looks like that: "8-5" after pasting looks like that: "08-may". I have formatted the cells before and after pasting, but the result was unsatisfactory. When I format beforehand - there is no difference. When I format after - in this cell apperas a 5-digit number. Can somebody help to solve the problem? Best regards Jurek. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Windows XP Excell - sheet 1 / shhet 2 / sheet 3... | Excel Discussion (Misc queries) | |||
Problem with shared workbook (history sheet) | Excel Worksheet Functions | |||
How do I insert a scroll bar into the excell sheet? | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |