{"id":1080,"date":"2025-01-22T19:22:44","date_gmt":"2025-01-22T18:22:44","guid":{"rendered":"https:\/\/wp.bizoir.dk\/?p=1080"},"modified":"2025-01-28T20:40:55","modified_gmt":"2025-01-28T19:40:55","slug":"excel-no-more-conversion-of-large-numbers-to-scientific-notation","status":"publish","type":"post","link":"https:\/\/wp.bizoir.dk\/?p=1080","title":{"rendered":"Excel : No more conversion of large numbers to Scientific Notation"},"content":{"rendered":"

To my extremely great surprise, Microsoft has finally fixed a very annoying feature in Excel.<\/p>\n

When importing CSV-files to Excel that contained (what could look like) a number, Excel would without fail convert that to a number during import and, if it was large enough like 1000000000001234567, convert it to Scientific Notation (1.000E+18) and in the process remove precision in the number. Even if you later forced it back to text or similar, it had forever lost the precision (1000000000001234000) and was hence utterly useless.<\/p>\n

That is happily a feature in the past for Office 365. Now you can disable this impressively stupid behaviour in “Options”<\/p>\n

<\/p>\n

Source data looks like this (from browser or textdocument)<\/p>\n

\"data
Data to be copied<\/figcaption><\/figure>\n

When imported (either via CSV file open, or just copy\/paste), Excel transforms to scientific notation<\/p>\n

\"Old
Old behaviour – imported as Scientific number<\/figcaption><\/figure>\n

If the number in scientific notation is forced back to a normal number, last digits has been lost<\/p>\n

\"Precision
Precision was lost during import<\/figcaption><\/figure>\n

But, happily, new options settings allow you to avoid this conversion (top two options)<\/p>\n

\"New
New options in Office 365<\/figcaption><\/figure>\n

Now when imported, the numbers are shown as numbers without any lost precision<\/p>\n

\"Success
Success – no Scientific Notation and no loss of precision<\/figcaption><\/figure>\n

Ref.: superuser.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

To my extremely great surprise, Microsoft has finally fixed a very annoying feature in Excel. When importing CSV-files to Excel that contained (what could look like) a number, Excel would without fail convert that to a number during import and, if it was large enough like 1000000000001234567, convert it to Scientific Notation (1.000E+18) and in … Continue reading “Excel : No more conversion of large numbers to Scientific Notation”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[40],"class_list":["post-1080","post","type-post","status-publish","format-standard","hentry","category-diverse","tag-office"],"_links":{"self":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/1080","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1080"}],"version-history":[{"count":8,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/1080\/revisions"}],"predecessor-version":[{"id":1093,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=\/wp\/v2\/posts\/1080\/revisions\/1093"}],"wp:attachment":[{"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.bizoir.dk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}