Hello community!
This is something that is recent in my Excel and it is bothering me.
See, about 50% of the time the following is happening:
If I enter a formula that has some basic operations from cells and also number operations, the number operation gets evaluated and not kept the way I entered them. What I mean is this:
I enter in the formula bar =A5*1400*(9/7)
when I press Enter and then go back to the formula bar I find this in the formula bar =A5*1400*(1.28571428571429)
I don't want that, I want to keep seeing the 9/7 operation because THAT makes sense to me when in the future I revisit de formula.
Why is this happening some times? It is not all the time, but some times it is indeed happening and it is making me crazy.
Please help me out.
Thank you!!!
Bookmarks