View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Copying and Pasting from INTERNET to Excel Spreadsheet

When you import the data (through the text import wizard?), specify the
format of the relevant columns as being text.
--
David Biddulph

"F. Lawrence Kulchar" wrote in
message ...
I am trying to copy a multicolumn table to my spreadsheet;

However, for about 5 of the fifteen columns, I get a "DATE",
such as

1-3-2000

instead of 1-3-1....which means the team won 1, lost 3, and tied 1.

If I reformat the " 1/3/2000 ", I get 36528 (i.e., the date's numerical
equivalent) -- i.e. still does NOT work.

Also, some columns have roughly half the numbers copied correctly, while
the
rest of the column is, again, an apparent "DATE".

Can anyone help please?

Thanks,

FLKulchar