Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
patricklundmark
 
Posts: n/a
Default barcode scan changes last 2 digits in excel 2003

I have been busy scanning comics in for my shop and i just found out as i
have been pluging in the barcode scan it changes the last 2 digits from 11 to
00. this only happens on the periodicals that end in 11. i have tried
changing the format from number with no decimels. and it still does it. i
type in the last 11 and yet it changes to zeros when i switch feilds.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default barcode scan changes last 2 digits in excel 2003

How many digits? Excek has 15 digits precision so anything beyond that will
be truncated to zeros


--

Regards,

Peo Sjoblom


"patricklundmark" wrote in
message ...
I have been busy scanning comics in for my shop and i just found out as i
have been pluging in the barcode scan it changes the last 2 digits from 11

to
00. this only happens on the periodicals that end in 11. i have tried
changing the format from number with no decimels. and it still does it. i
type in the last 11 and yet it changes to zeros when i switch feilds.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
patricklundmark
 
Posts: n/a
Default barcode scan changes last 2 digits in excel 2003

ah yep for the periodicals it is 17 digits. so excel cant handle more?

"patricklundmark" wrote:

I have been busy scanning comics in for my shop and i just found out as i
have been pluging in the barcode scan it changes the last 2 digits from 11 to
00. this only happens on the periodicals that end in 11. i have tried
changing the format from number with no decimels. and it still does it. i
type in the last 11 and yet it changes to zeros when i switch feilds.

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default barcode scan changes last 2 digits in excel 2003

It can, but not as a number. Format the cell as text before entering the
number, or precede the number with a single quote (which will not show)

--
Kind regards,

Niek Otten

"patricklundmark" wrote in
message ...
ah yep for the periodicals it is 17 digits. so excel cant handle more?

"patricklundmark" wrote:

I have been busy scanning comics in for my shop and i just found out as i
have been pluging in the barcode scan it changes the last 2 digits from
11 to
00. this only happens on the periodicals that end in 11. i have tried
changing the format from number with no decimels. and it still does it. i
type in the last 11 and yet it changes to zeros when i switch feilds.



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default barcode scan changes last 2 digits in excel 2003

Pre-format the cells as text. Excel will retain all 17 digits in that case

Disclosure - don't have experience with Excel input via barcode scanners, so
no guarantees

"patricklundmark" wrote:

ah yep for the periodicals it is 17 digits. so excel cant handle more?

"patricklundmark" wrote:

I have been busy scanning comics in for my shop and i just found out as i
have been pluging in the barcode scan it changes the last 2 digits from 11 to
00. this only happens on the periodicals that end in 11. i have tried
changing the format from number with no decimels. and it still does it. i
type in the last 11 and yet it changes to zeros when i switch feilds.



  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default barcode scan changes last 2 digits in excel 2003

Patrick

Excel recognizes only 15 significant digits.

Any number more that 15 digits will have the extra digits turned to zeros.

Perhaps only those numbers ending in 11 are more than 15 digits?

Preface the numbers with an apostrophe to enter them as text.

For scanning I would suggest you format the cells as Text before scanning in.

Can you perhaps scan to a *.txt file then use the DataText to Columns Import
Wizard?


Gord Dibben Excel MVP

On Fri, 18 Nov 2005 12:06:02 -0800, patricklundmark
wrote:

I have been busy scanning comics in for my shop and i just found out as i
have been pluging in the barcode scan it changes the last 2 digits from 11 to
00. this only happens on the periodicals that end in 11. i have tried
changing the format from number with no decimels. and it still does it. i
type in the last 11 and yet it changes to zeros when i switch feilds.


  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default barcode scan changes last 2 digits in excel 2003

Of course! Apostrophe! Keep these.

--
Kind regards,

Niek Otten

"Niek Otten" wrote in message
...
It can, but not as a number. Format the cell as text before entering the
number, or precede the number with a single quote (which will not show)

--
Kind regards,

Niek Otten

"patricklundmark" wrote in
message ...
ah yep for the periodicals it is 17 digits. so excel cant handle more?

"patricklundmark" wrote:

I have been busy scanning comics in for my shop and i just found out as
i
have been pluging in the barcode scan it changes the last 2 digits from
11 to
00. this only happens on the periodicals that end in 11. i have tried
changing the format from number with no decimels. and it still does it.
i
type in the last 11 and yet it changes to zeros when i switch feilds.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Very slow in opening Excel 97 file in Excel 2003 S M Setting up and Configuration of Excel 0 October 22nd 05 07:32 PM
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
Excel Re-calculation 2000 compared to 2003 tonymitchell Excel Discussion (Misc queries) 1 August 3rd 05 04:22 PM
Excel 2003 crashes loading excel files created Excel 2000 Jeff Lewin Australia Excel Discussion (Misc queries) 0 June 27th 05 04:20 AM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 08:27 PM


All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"