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?)

Driver wrote:
>
> 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
>
> --
> Driver
> ------------------------------------------------------------------------
> Driver's Profile: http://www.excelforum.com/member.php...o&userid=30222
> View this thread: http://www.excelforum.com/showthread...hreadid=498991

--

Dave Peterson