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 a week 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.