L

#### Legacy 386498

##### Guest

I have an Excel file that is pretty simple, 2 cells are link to other tabs and the third one sums the first two. Problem is I want to hide the decimal (whole numbers only), but when I decrease the decimals in the first two columns, the decimal disappears. So for example, if we take cell A6 (192.93) and you decrease one decimal, the sum shows 192.90 and not 192.93. And if you undo, cell A6 is now 192.90 instead of the 192.93 we had initially.

Also, if you hide the decimals from the first sum (cell C3), cell F3 will show an error (#DIV/0!), even if the sum is higher than 0.

I've uploaded the file here:

http://www.filedropper.com/excel

And another one to show that in this new file if you decrease the decimals from cell C2 so it becomes 0, you'll see that cell F2 doesn't become #DIV/0!, the result stayed the same whether you can see the decimals or not. So I'm trying to know why it isn't the same with my other file.

http://www.filedropper.com/book1_20

Thank you and have a nice day.