Home |
Search |
Today's Posts |
#1
|
|||
|
|||
16th digit in the cell changes to a zero??
Our company uses a program that has some inventory items that are 16
numerical digits long. When I run an export to a csv file. I notice that after opening the file, all the cells that have skus which are 16 digits long, get changed to end with a zero instead of the real number. After some labored testing, I finally decided to try to manually input a sample number into excel and noticed that the 16th digit gets changed everytime to a zero. Is there a fix or way to keep this from happening? Thanks in advance for your help. Roman |
#2
|
|||
|
|||
Excel's precision for numbers is 15 significant digits.
If an identifying item, such as credit card number or product number has to be used, don't treat it as a number, since it is not meant to calculate with. Treat is as text can be done in several ways: enter an apostrophe before entering the number (the apostrophe will not show) or format the cells as text before entering the numbers. Or have the exporting program export something like A12345678901234567 (add an "A") and remove the A in Excel. -- Kind Regards, Niek Otten Microsoft MVP - Excel " wrote in message ... Our company uses a program that has some inventory items that are 16 numerical digits long. When I run an export to a csv file. I notice that after opening the file, all the cells that have skus which are 16 digits long, get changed to end with a zero instead of the real number. After some labored testing, I finally decided to try to manually input a sample number into excel and noticed that the 16th digit gets changed everytime to a zero. Is there a fix or way to keep this from happening? Thanks in advance for your help. Roman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell addressing using the content of another cell. | Excel Worksheet Functions | |||
how can i get a cell to hold a zero in front of a digit ie. 01 or. | Excel Discussion (Misc queries) | |||
excel - numbers as text | New Users to Excel | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
16 DIGIT NUMBERS IN CELL WITHOUT LAST DIGIT BEING A ZERO | Excel Worksheet Functions |