See the attached pictures for one example, when I typed $4.8 it changes to $5 when I click away from it, and when I click it again it changes back (temporarily).
It sometimes does that and sometimes doesn't, I can't figure out why.
Also when I use Sum to get the total it sometimes counts the number as it shows (rounded) and sometimes counts it as the way I typed it.
How do change it to always show exact numbers?
It sometimes does that and sometimes doesn't, I can't figure out why.
Also when I use Sum to get the total it sometimes counts the number as it shows (rounded) and sometimes counts it as the way I typed it.
How do change it to always show exact numbers?