Scanning a Number into Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Driver - 07 Jan 2006 12:18 GMT

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

Signature

Driver

Reply to this Message

Roger Govier - 07 Jan 2006 12:25 GMT

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.

Signature

Regards

Roger Govier

> 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

Reply to this Message

Dave Peterson - 07 Jan 2006 15:29 GMT

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

> 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
[quoted text clipped - 7 lines]
> Driver's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30222
> View this thread: http://www.excelforum.com/showthread.php?threadid=498991

Signature

Dave Peterson

Reply to this Message