a problem with pasting into Excell sheet

J

Jurek

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.
 
D

Dave Peterson

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top