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?
View best response
Either the column width is too small to show the decimals or the number format prevents showing the decimals.
It is still not working. It keeps on giving me 0
Most probably cell formatting. Not sure which version of Excel do you use, try to apply currency format with two decimal numbers (cents).
Thank you. Just fixed it.
May 30, 2020
May 25, 2020
May 21, 2020
May 17, 2020
Microsoft Ignite The Tour 2019
February 14, 2020