Question about pasting web content and formats

3

39N95W

I am trying to paste the baseball standings from a web page onto a
spreadsheet. The data pastes very nicely since it is already in a table
format. However, some of the data on the web lists Home, Away and Last 10
records as "10-6", "3-7", etc. When I paste this onto the spreadsheet it
automatically assumes it is a date and thus changes the data.

Can this auto-formatting be temporarily disabled? Sometimes Excel is just
too smart for it's own good.

Anyway, any suggestions would be greatly appreciated.

TIA!

-gk-
 
Top