If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sending same data to multiple noncorresponding cells | rclark | General Discussion | 13 | September 13th, 2004 06:49 PM |