Message 1 of 7
Decimal number
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
It's not that big of a deal, but I just want to know why it's happening...
I have my data cell as 0.00 precision decimal number. When I enter a number that's ending in 5 in the 10th decimal place, it rounds up so it'll show up as a number I want. (For example 1.05) However, when I click the cell to edit the number, it shows up as .04999999...1 Why it's happening like this? (Attached is the reference image I'm talking about)