![]() ![]() I have also chosen Home>Editing>Clear>Clear All, which reverts it back to E+, and re-applied the Number (0 places), resulting in the same rounding down to 2 0. Can anyone give an explanation and tell me how to stop it? There is no function (ROUND) associated with the cell, at least, not that I can see. I have just inserted 357821089695082 6 to a cell with this cell format, and noticed that it is being changed to 357821089695082 0. However, I thought I was working around this, by changing the cell properties to Number (Decimal Places =0) ![]() It has annoyed me for years that there is no simple way to set a default in Excel, to allow 'long number'. I often use Excel to store mobile telecoms data, MSISDN (commonly known as your phone number, 12 digits), IMSI (sim, 15 digits), IMEI (handset, 16 digits). Excel Subscription Product, Microsoft 365 Apps for enterprise
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |