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
|