Jul 16 2019 09:25 PM
I'm not sure why this is not working. I'm trying to divide a cell (8) by a certain number (20) and it gives me the answer "0" because the answer would be a decimal. Is there anyway to fix that?
Jul 16 2019 09:46 PM
Either the column width is too small to show the decimals or the number format prevents showing the decimals.
Jul 17 2019 11:02 AM
Jul 17 2019 01:51 PM
Jul 17 2019 02:05 PM
SolutionMost probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).
Jul 17 2019 02:05 PM
SolutionMost probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).