Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
number too long
i have range a2:a100 that i scan items into, the length of the barcode number
ranges from 10 - 20 digits. when i scan an item that is 20 digits long it converts the last 5 digits to zeros. i tried formatting the cells to 20 zeros but then if i scanned something with 10 digits it would add another 10 zeros. i was thinking of a conditional formatting but i cant seem to get it. please help thank you in advance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
number too long
You need to format the cells as Text
Excel only has 15 digits of precision, so if you try to store a number with more than 15 digits, the digits above 15 will be converted to 0. -- Regards, Tom Ogilvy "choice" wrote in message ... i have range a2:a100 that i scan items into, the length of the barcode number ranges from 10 - 20 digits. when i scan an item that is 20 digits long it converts the last 5 digits to zeros. i tried formatting the cells to 20 zeros but then if i scanned something with 10 digits it would add another 10 zeros. i was thinking of a conditional formatting but i cant seem to get it. please help thank you in advance |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
number too long
You're reaching the limit of how big a number can be stored.
Try to format the cell as Text instead. -- Rob van Gelder - http://www.vangelder.co.nz/excel "choice" wrote in message ... i have range a2:a100 that i scan items into, the length of the barcode number ranges from 10 - 20 digits. when i scan an item that is 20 digits long it converts the last 5 digits to zeros. i tried formatting the cells to 20 zeros but then if i scanned something with 10 digits it would add another 10 zeros. i was thinking of a conditional formatting but i cant seem to get it. please help thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
when I type a long number it shows up as smaller number and + | Excel Discussion (Misc queries) | |||
formula to add a number to a long string ** | Excel Worksheet Functions | |||
long number ends in 000 | Excel Discussion (Misc queries) | |||
display long number as text | Excel Programming |