how can I convert scanned data into usable numbers in excel?
 

We scan satisfaction data and send it to an excel spreadsheet. When I cut
and paste the data into a spreadsheet that tallies the information, the
scanned data is apparently not recognized as numbers as it will not
calculate. Any ideas. I've tried changing the format and pasting just the
values and this has not worked.

how can I convert scanned data into usable numbers in excel?
 

You have to process your image data thru an OCR (Optical Caracter
Recognition) program

HTH
--
AP

"lk0119" a écrit dans le message de
...
We scan satisfaction data and send it to an excel spreadsheet. When I cut
and paste the data into a spreadsheet that tallies the information, the
scanned data is apparently not recognized as numbers as it will not
calculate. Any ideas. I've tried changing the format and pasting just
the
values and this has not worked.

how can I convert scanned data into usable numbers in excel?
 

If they are text looking like numbers, copy an empty cell, select the
import and do editpaste special and select add


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"lk0119" wrote in message
...
We scan satisfaction data and send it to an excel spreadsheet. When I cut
and paste the data into a spreadsheet that tallies the information, the
scanned data is apparently not recognized as numbers as it will not
calculate. Any ideas. I've tried changing the format and pasting just
the
values and this has not worked.