Feature Summary

The number format feature allows users to format numbers in cells, including display options such as numeric precision, currency symbols, percentages, and dates, making data presentation more intuitive and standardized.

Feature Description

Feature Dimension Description
Membership Restriction No membership restriction
Version Restriction No version restriction

Operation Steps

Quick Settings via Toolbar

Feature Entry
「Home」 tab → 「Number Format」 dropdown menu

  1. Select the cell or cell range where you want to set the number format
  2. Click the top 「Home」 tab
  3. Click the 「Number Format」 dropdown menu (default display is 「General」)
  4. Select the desired number format from the dropdown list (Number, Currency, Percentage, Short Date, etc.) to apply it with one click

image

Settings via Right-Click Menu

Feature Entry
Select cell → Right-click → 「Format Cells」

  1. Select the cell or cell range you want to set
  2. Right-click and select 「Format Cells」 from the pop-up menu
  3. In the pop-up dialog, switch to the 「Number」 tab
  4. Select the desired format type from the 「Category」 list (Number, Currency, Date, Text, Custom, etc.)
  5. Adjust the specific parameters as needed (such as decimal places, currency symbol, format code, etc.)
  6. Click the sheet editing area to apply the settings

image

Settings via Shortcut

Feature Entry
Select cell → Shortcut Ctrl+1

  1. Select the cell or cell range you want to set
  2. Press the shortcut Ctrl+1 to quickly bring up the 「Format Cells」 dialog
  3. Subsequent operations are the same as steps 4-6 of the right-click menu settings

Custom Number Format

Feature Entry
「Format Cells」 → 「Number」 tab → 「Custom」 category

  1. Select the cell you want to set
  2. Open the 「Format Cells」 dialog (via right-click menu or Command+1)
  3. In the 「Number」 tab, select the 「Custom」 category on the left
  4. Enter the custom format code in the 「Type」 input box, for example:
  • Plain number: enter 0
  • Two decimal places with unit: enter 0.00"yuan", displayed as 123.45yuan
  • Date with day of the week: enter yyyy-mm-dd aaaa
  • Preserve leading zeros: enter 00000, entering 12 displays as 00012
  1. Click 「Add & Apply」 to complete the settings

image

FAQ

Q1: What should I do if the cell displays a string of hash marks (#) after setting the number format?

  • Solution: This usually occurs because the column width is insufficient to display the complete formatted content. Manually drag to increase the column width to display it normally.

Notes

  1. Number format only changes the display method and does not affect the actual value stored in the cell
  2. Different formats can be switched between each other, and the data will be re-displayed according to the new format after switching
  3. In custom format codes, text within half-width double quotation marks is fixed additional content
  4. In the 「Home」 tab, you can quickly change the cell number format to percentage and increase/decrease decimal places