I don't know if this would work in your particular case, but what I use to do
is first paste the website copied contents to notepad, and then from notepad
to Excel. Later I usually have to use the "Text to columns" option, but at
least I got rid of much of the web format.
With a pdf, you may try to export to text, and check if you can do something
with that plain file in Excel.

"Erik Todd" wrote:

We work with a customer who provides the parts they need on a website that
can only be saved as a PDF file so that it is easy for use to print. We use
excel to forecast their requirements and must manually input values into the
spreadsheet. All our other accounts provide us an excel format that we use
very easily with our spreadsheet.

How can I copy numbers from a website and paste into an Excel spreadsheet
and make the values work as numbers? They work as bitmaps for some reason and
only if I re-type them do they work. I have already tried copy and paste
special