View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default IMPORT DATA FROM WEB - WON'T DOWNLOAD SPECIAL CHARACTERS

As the name suggests, it imports data not formatting...

If you right-click on any webpage and choose View Source (in Internet
Explorer) you will see that even there data is separate from formatting... I
mean strikethrough is applied to data (text), data itself does not have
formatting...

You can format the cells/columns after import as per your requirement...

or may try cutting and pasting... which retains most of the formatting...

"Sacs" wrote:

I have a site that use a strikethrougt on certain names , however when I
download the data through the Import Data feature ... it does not download
the strikethrough ... why is it I'm able to get * characters or others and
not any kind of formatting I am using Excel 2003 . Is this possible with
2007?

This is the webpage I download from
http://league1.protourfantasygolf.com/weekly_results

Any help would be greatly appreciated