mrMadCat
New Member
- Joined
- Jun 8, 2016
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Hi!
I have a simple column with numbers. There is no single number that has more than 2 decimals. Yet the total for this numbers is "-9 927 260,89999999". I would upload the xlsx file but I don't see such option, unfortunately (strange). So here is the link to my onedrive for now: Book2.xlsx
That is... weird ))) I remember something from long ago about how excel calculates numbers and that there are some things in programing language that make it deviate from classic algebra. Yet this is strange. Especially since how important the decimals can be, for example for cryptocurrencies, or some space calculations.
I have a simple column with numbers. There is no single number that has more than 2 decimals. Yet the total for this numbers is "-9 927 260,89999999". I would upload the xlsx file but I don't see such option, unfortunately (strange). So here is the link to my onedrive for now: Book2.xlsx
That is... weird ))) I remember something from long ago about how excel calculates numbers and that there are some things in programing language that make it deviate from classic algebra. Yet this is strange. Especially since how important the decimals can be, for example for cryptocurrencies, or some space calculations.