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.

--
Regards

Roger Govier


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

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

[niturao]

how to scan 15 digit numbers to excel is there any scanner for that??

[Speshul]

Please start a new thread if you have a new question; this thread is almost 9 years old.