Hello guys! I would like to ask a simple question that has stumped me for 2 years in using Excel.
I've been using a simple formula, just a summation, to calculate the payroll. I make sure that there are only two decimal points. However, recently it has come back again. Whenever I copy-pasted or typed zero on an empty cell, the result will return to (0.00) which is a negative number.
Attached herewith is the sample workbook.
I could ignore it but it irks my eyes and I am getting distracted
If I could, I want to know the underlying problem. I know I can use the round formula but that will be my last resort
Bookmarks