{"id":20120,"date":"2017-02-17T00:55:21","date_gmt":"2017-02-17T00:55:21","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=20120"},"modified":"2017-02-17T01:07:03","modified_gmt":"2017-02-17T01:07:03","slug":"spreadsheets-excel-libreoffice-calc-number-formatting-how-to-get-rid-of-e-05-for-example","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-excel-libreoffice-calc-number-formatting-how-to-get-rid-of-e-05-for-example\/","title":{"rendered":"Spreadsheets: Excel, LibreOffice Calc: number formatting: how to get rid of E-05 (for example)"},"content":{"rendered":"

The tutor explains how to change from scientific notation to regular number format in Excel or LibreOffice Calc.<\/h1>\n

In my post from Feb 14<\/a> I mention that 1.69e-05 equals 0.0000169. Written 1.69e-05, the number is in scientific notation. Perhaps the user is not familiar, or not comfortable with that format – what can be done?<\/p>\n

    \n
  1. \nRight-click the cell with the number in scientific notation.<\/li>\n
  2. \nClick Format Cells…<\/li>\n
  3. \nClick Number. There is a click box for the number of decimal places; if the number is in scientific notation with e-05 or such, you’ll likely need lots (maybe 10 or more). There are also choices for how you want the number to appear; select the one desired.<\/li>\n
  4. \nClick OK: Hopefully the number will now be in “ordinary” format.<\/li>\n
  5. You may need to widen the column to accommodate the number.<\/li>\n
  6. \nIf there is a positive number after the e, the cell contains a large value: for example, 1e+06 is 1 000 000. In such a case, you probably won’t need more decimal places, but might need to widen the column to accommodate the number in regular format:)\n<\/li>\n<\/ol>\n

    Jack of Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"

    The tutor explains how to change from scientific notation to regular number format in Excel or LibreOffice Calc. In my post from Feb 14 I mention that 1.69e-05 equals 0.0000169. Written 1.69e-05, the number is in scientific notation. Perhaps the …<\/p>\n

    Spreadsheets: Excel, LibreOffice Calc: number formatting: how to get rid of E-05 (for example)<\/span> Read More »<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[371,1073,1583,1951,1065],"tags":[2140],"class_list":["post-20120","post","type-post","status-publish","format-standard","hentry","category-business","category-computer-skills","category-excel","category-libreoffice-calc","category-spreadsheets","tag-formatting-numbers"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/20120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=20120"}],"version-history":[{"count":14,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/20120\/revisions"}],"predecessor-version":[{"id":20134,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/20120\/revisions\/20134"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=20120"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=20120"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=20120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}