Scanning a Number into Excel

[Driver]

I am trying to scan a number that is 24 digits long into an Excel spread
sheet. I have formated the cells to numbers and removed the decimal
places and it scans into the cell but when i move to the next cell it
changes the last 9 digits to 0. Is there some way to keep all the 24
digits? Thanks

 

[Roger Govier]

Hi Driver

Excel's numbers are limited to 15.
You need to have the cell formatted as Text, if you want to have numbers
greater than 15 digits entered.

 

[Dave Peterson]

Any chance you can scan to a .Txt file and then use excel's File|open to open
that text file?

You'll see the text import wizard open and you'll be able to tell excel to treat
those long digit fields as text.

(Or is there an option in your scanning software where you specify the field
type (Text) for excel?)