This is because Excel automatically abbreviates numbers over 11 digits in length. To fix this, click on the column header and click Format Cells->As Number->0 decimal places.
H
Written by Harini
Updated over 6 months agoThis is because Excel automatically abbreviates numbers over 11 digits in length. To fix this, click on the column header and click Format Cells->As Number->0 decimal places.