karelbarel
New Member
- Joined
- Feb 10, 2021
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
Hello, I tried substracting two numbers, 0.0083 and 0.009 Nothing else, just those two numbers in two cells and result in third, but excel is rounding weirdly when i display enough decimals. How can I fix this? It's mesing up conditional formatting.
Thanks for any help
Thanks for any help
Sešit1 | |||
---|---|---|---|
F | |||
12 | 0,0083000000000000000000 | ||
13 | 0,0090000000000000000000 | ||
14 | -0,0006999999999999990000 | ||
List1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F14 | F14 | =F12-F13 |