以科學記號 (指數) 表示法顯示數字

科學記號格式會以指數表示法顯示數字,以 E+n 來取代部分的數字,其中 E (代表指數) 會將其前面的數字乘以 10,再將乘積乘 n 次方。例如,兩位小數的科學記號格式會將 12345678901 顯示為 1.23E+10,也就是 1.23 乘以 10 的 10 次方。

  1. 選取您要設定格式的儲存格。

    如何選取儲存格、範圍、列或欄

    選取

    請執行此動作

    A single cell

    Click the cell, or press the arrow keys to move to the cell.

    A range of cells

    Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection.

    You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.

    A large range of cells

    Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.

    All cells on a worksheet

    Click the Select All button.

    [全選] 按鈕

    若要選取整份工作表,您也可以按 CTRL+A 鍵。

    附註  If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.

    Nonadjacent cells or cell ranges

    Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.

    You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. To stop adding cells or ranges to the selection, press SHIFT+F8 again.

    附註  You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection.

    An entire row or column

    Click the row or column heading.

    顯示列名及欄名的工作表

    1. 列名

    2. 欄名

    You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).

    附註  If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell. Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column.

    Adjacent rows or columns

    Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.

    Nonadjacent rows or columns

    Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection.

    The first or last cell in a row or column

    Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).

    The first or last cell on a worksheet or in a Microsoft Office Excel table

    Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.

    Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting.

    Cells to the last used cell on the worksheet (lower-right corner)

    Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet (lower-right corner).

    Cells to the beginning of the worksheet

    Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet.

    More or fewer cells than the active selection

    按住 SHIFT 鍵並按一下您要包含在新選取範圍內的最後一個儲存格。作用儲存格與您所按的儲存格之間的矩形範圍隨即成為新的選取範圍。

    提示  若要取消選取儲存格,按一下工作表上的任一個儲存格即可。

  2. 在 [常用] 索引標籤上,按一下 [數值] 旁的 [對話方塊啟動器]按鈕圖像

    Excel 功能區圖像

  3. 在 [類別] 清單中,按一下 [科學記號]。

  4. [小數位數] 方塊中,輸入您想要顯示的小數位數數目。

    提示  在工作表上,選取範圍的作用中儲存格數字會顯示在 [範例] 方塊中,讓您預覽您選取的數字格式設定選項。

附註  

  • 若要快速地以科學記號表示法設定數字的格式,請按一下 [數值格式] 方塊 ([常用] 索引標籤的 [數值] 群組) 中的 [科學記號]。科學記號表示法的預設值是兩位小數位數。

  • 數字格式不會影響 Microsoft Excel 用來進行計算的實際儲存格值。實際的值會顯示在資料編輯列中。

  • 數字的最高精確度是 15 位數。更高的數字 (15 位數以上) 在公式列中顯示的實際值可能會改變。

  • 若要重新設定數字格式,請按一下 [數值格式] 方塊 ([常用] 索引標籤的 [數值] 群組) 中的 [通用格式]。以 [通用格式] 設定格式的儲存格並不會使用特定的數字格式,但是,[通用格式] 會針對比較大的數字 (12 或更高位數) 使用指數表示法。若要移除較大數字的指數表示法,您可以套用不同的數字格式,如 [數值]

適用: Excel 2007



這項資訊有幫助嗎?

我們應該如何改進?

255 剩餘字元數

若要保護您的隱私,請不要在意見反應中包含連絡資訊。 檢閱我們的 隱私權原則

感謝您的意見反應!

變更語言