I've had similar problems and learned that in my case this happened when I
had used the text-to-columns wizard in between times of importing data grids.
It's strange, but I had to make sure my most recent use of the wizard was as
"delimited by tabs option" then shut down Excel then go back in. Then try
your web query import again and it should work. Hope this helps...

steve

"Tenacity" wrote:

If there is a table of figures on a web site, is there a way to copy and
paste into Excel so the figures stay in the same columns as on the site, and
can be worked on as numbers within Excel.

Paste Special sometimes works (by pasting as Text, Unicode Text or even
HTML) and sometimes it doesn't (all the data gets pasted into column A and
not spread across columns).

I realize this might be a function of how the HTML is written on the web
site, but is there some conversion tool out there which will yield consistent
results?

Tx for your help and suggestions.