【EXCEL】EXCEL 2010 - 數字變成科學符號?

<div class="jane_bar" style="margin: auto auto 35px; padding: 20px; border-width: 5px 0px 0px; border-style: solid dotted dotted; border-color: RGB(33,115,70) gray gray; border-image: initial; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 16px; line-height: 50px; font-family: "Microsoft JhengHei", cwTeXHei, "Open Sans"; vertical-align: baseline; color: rgb(40, 40, 40); letter-spacing: 1px; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; border-radius: 0px; width: 100%; background-color: rgb(207, 241, 222); box-sizing: border-box; text-align: center;"> 【EXCEL】EXCEL 2010 - 數字變成科學符號?

EXCEL 中輸入的數字若變成了科學符號,要如何讓其顯示出正常的數字?

步驟一:1用滑鼠選取想要正常顯示的區域。 2 選「儲存格格式」

(adsbygoogle = window.adsbygoogle []).push({});

步驟二:1 數值 2 自訂 3 輸入「0」 4 按「確定」

步驟三:回到工作頁,即可看到數字的部分已經從科學符號的顯示方式,變為一般的數字了。

<h2 class="ih-heading" style="margin: 0px 0px 15px; padding: 0px; border-width: 0px 0px 2px 2px; border-top-style: initial; border-right-style: initial; border-bottom-style: solid; border-left-style: initial; border-top-color: initial; border-right-color: initial; border-bottom-color: RGB(33,115,70); border-left-color: rgb(2, 141, 99); border-image: initial; font-style: inherit; font-variant: inherit; font-weight: normal; font-stretch: inherit; font-size: 18px; line-height: 1; font-family: inherit; vertical-align: baseline; color: rgb(40, 40, 40); orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; letter-spacing: 0.7px; background-color: rgb(255, 255, 255);"> 延伸閱讀

<p style="margin: 1em 0px; padding: 0px; border: 0px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-weight: 400; font-stretch: inherit; font-size: 1.1rem; line-height: 1.75rem; font-family: "Noto Sans TC", 微軟正黑體, sans-serif; vertical-align: baseline; color: rgb(52, 52, 52); letter-spacing: 1px; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; background-color: rgb(255, 255, 255);"> EXCEL 相關文章🔍

#【EXCEL】EXCEL 2010 - 數字變成科學符號

(adsbygoogle = window.adsbygoogle []).push({});

隨手記錄

本部落格由數名好友共同撰寫。記錄生活中的點點滴滴。內容包含食、衣、住、行、育、樂上的各種記錄及經驗分享。若有牽涉到店家的任何資訊，皆僅供參考。正確性及時效性，請依原店家公告為主。