Forum Discussion

NormanRShapiro's avatar
NormanRShapiro
Copper Contributor
Jun 25, 2020

SUM display not displaying properly.

Just upgraded to Excel 2019. There is a display underneath the bottom of the worksheet that displays things like "Average", "Count" and "Sum" on all the cells that are highlighted. On many of my sheets (but not all), the "Average" and "Sum" figures do not display correctly (They cut off the last digit). I use this feature ALL the time, and never had this issue with past versions. I've attached a file as well as a JPEG showing the problem.

1 Reply

  • Bennadeau's avatar
    Bennadeau
    Iron Contributor

    Hi NormanRShapiro,

    I see how this can be annoying. While I can't reproduce this behavior on my end, first thing I would try is a Full repair of Office. 

    You can also run the following command in an elevated command prompt (if you have admin rights)

    sfc /scannow

    Then reboot your computer and see if it helps.

    Good luck

     

    Ben 

Resources