This is because Excel automatically abbreviates numbers over 11 digits in length. To fix this, select the cells, right-click and click Format Cells > Number tab > Number. Number>0 decimal places.
Why do numbers look like 4.47741E+12 when I export them to Excel?
H
Written by Harini
Updated over a month ago