Forum Discussion
Solved
Very simple Division question
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?
Most probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).
Most probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).