Question about pasting web content and formats

  • Thread starter Thread starter 39N95W
  • Start date Start date
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-
 
You must log in or register to reply here.

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

Similar Threads

paste web without date format 1
Pasted values that paste as "number stored as text" 3
Cut & Paste in Excel without erasing cell borders? 1
Excel 2007 and Paste Special with HTML and data from the web 3
pasting content copied from nonadajacent cells 1
format and paste problems 2
format troubles - possible cut/paste issue 8
Formatting - Pasting fm external app 1

Back
Top