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.

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.

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.