Hi there,

Excel itself can do it
Select the cells where you want to show such long numbers. Press Ctrl + 1 to open the Format Cells window.
Under the tab Number, select Number in the Category list, set Decimal places as 0. See screenhot:



Amanda

Thanks Amanda, Is there anyway for excel to display the correct number once it does this "5.26722E+15" ? In otherwords, i need to know what the last digit was before excel changed it to a zero?

Quoted from Amanda Lee on Friday, 20 May 2022

Press Ctrl + 1 to open the Format Cells window.
Under the tab Number, select Number in the Category list, set Decimal places as 0.

Hi there,

If you want Excel to automatically fully display such long numbers, you can select the area where such numbers could appear, and then apply the number format I mentioned above.

Note that do not apply the number format to the range where includes dates, times or other number formats. If you do, these values will be converted to pure numbers.

Amanda