Values from website turned into useable number values
 

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

Values from website turned into useable number values
 

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

Values from website turned into useable number values
 

Erik

Format the data as General.

Copy an empty cell.

Select the data cells and Paste SpecialAddOKEsc


Gord Dibben MS Excel MVP

On Fri, 28 Apr 2006 12:32:02 -0700, Erik Todd <Erik
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

Values from website turned into useable number values
 

then you should be able to just right click the mouse when you point on
the table with numbers, select Export to Excel or something like that.
I am putting a disclaimer here since I don't know in what situations
that works. I did it a few times in the past when I had data from
clients in html format.

For PDF's, I've never been able to export numbers into Excel directly.
If the PDF file is an image scan, then it may be even more harder.
However, I've heard there is software that does the job for you. I
beleive it's call fine reader or something like that (need to pay). I
am sure there is free software similar to fine reader as well.

Proper


--
proper
------------------------------------------------------------------------
proper's Profile: http://www.excelforum.com/member.php...o&userid=33166
View this thread: http://www.excelforum.com/showthread...hreadid=537333