3 ms·
It’s not just a display issue. It will silently convert any digits past 16 into zeros with no way to retrieve them. Where i work, transaction records have an I
by Tagbert 4y ago
It’s not just a display issue. It will silently convert any digits past 16 into zeros with no way to retrieve them.
Where i work, transaction records have an ID that is a 20 digit numeric code. If you are not very careful when importing that, pasting that, or editing cells, Excel will just strip out data because it’s priority is to convert it to a lossy format.
- zamadatix 4y agoThat has to do with the backing number type in Excel being an double precision float not what the display convention of the value is.