Excel Sum Function is truncating trailing zero's while pasting Sum from one cell to another
Steps to reproduce the bug:
- Create Sum of 2 or more cells with numeric values - Ex. A4 = Sum(Sheet1!A2+Sheet2!A3)
- Copy the formula and paste it to other cells, so that it can take values from respective cells and create summation. Ex. Pasting Sum in B4, C4, D4...B12, C12, B15 etc.
- While pasting, its working correctly for B4(i.e. Sheet1!B2+Sheet2!B3), also for B15(i.e. Sheet1!B13+Sheet2!B14) where there the cell numbers are not ending with 0s.
- Its not working correctly for B12(it should be Sheet1!B10+Sheet2!B11) instead it is pasted as Sheet1!B1+Sheet2!B11. This is wrong. This is happening especially when we sum across sheets
I dont find an option to send feedback from my Excel version. So, sharing it here.
Excel Version - 2016
Windows version - 10
Sergei Baklan commented
To send feedback File->Feedback->Send a Frown. Microsoft monitors it. As for an issue I can't reproduce it.