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"...
Hi Jose,
Do you mean you see 0.75 in formula bar instead of =3/4 (and no such effect for =3+4) without pressing F9 for PC version?
Yes, in the formula bar the =3/4 is replaced with the result 0.75, therfore the cell also displays 0.75.
I have Office 365 (therefore, the latest version of Excel, i.e. 2016 in this case), PC version (running on Windows 10), and I do not press F9.
There is not such effect with additions, substractions or multiplications, only with divisions.
Thank you, Sergei.
Jose, to clarify - that's only with =3/4 or with any division, let say =10.741/3.14?
- It seems to happen with any division.
