Forum Discussion
Problem with numbers division
Hi, this should be a very easy one, but I've not been able to solve it. If I type a numbers division, like say "=3/4", Excel will automatically replace that simple formula with its result, "0.75"...
just so I have this correct you are looking at
3 4 0.75
3 4 =3+4
The Excel tool was built to Calculate 7 for the last cell and if you have =3+4 you will have had to fix it that way.
3 4 0.75
3 4 =3+4
The Excel tool was built to Calculate 7 for the last cell and if you have =3+4 you will have had to fix it that way.
If I type =3+4, the cell will display the result, 7, but it will keep the formula. If I type =3/4, the cell will also display the result, 0.75, but the formula will be replaced too with the result, loosing the formula (which I want to keep).
Thank you, Alun.
Thank you, Alun.