| 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 |
| 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 | |||
![choice[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
