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

[lk0119]

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.

[Ardus Petus]

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

HTH
--
AP

"lk0119" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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.

[Peo Sjoblom]

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"lk0119" <[email protected]> wrote in message
news:[email protected]...
> 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.