Apply Number Format in Excel and Google Sheets

Updated 8 November 2026 · Standard formula, shown below

To apply number format in Excel or Google Sheets, select the cell or range, then choose a format such as Number, Currency, Date, or Percentage from the spreadsheet’s formatting controls. Number formatting changes how a value is displayed, not the underlying value used in calculations; the exact steps depend on the app and device.

What Number Formatting Does

A spreadsheet stores values separately from the way it displays them. Formatting tells the program how to present a value: as a decimal, date, percentage, currency amount, or another recognized type. For example, the stored value 0.25 can appear as 0.25, 25%, or $0.25, depending on its format. Those displays do not mean the value itself was replaced.

This distinction matters when calculating. If a cell containing 0.25 is formatted as a percentage, a formula that uses it still uses 0.25. Likewise, displaying 3.5 as $3.50 does not add two decimal places to the stored value; it changes the presentation.

Formatting is different from converting a value into text. A number format generally preserves a numeric value for arithmetic, while text that merely looks like a number may not behave as one. Formatting also does not change the meaning of an invalid or incorrectly entered value.

Apply a Format in Excel

In the desktop version of Excel, select one or more cells, then use the number-format controls on the Home tab. The Number group offers common formats and controls for decimal places. You can also open the Format Cells dialog for more options. Names and screen layout can vary somewhat between desktop, web, and mobile versions.

Select the cell, cells, or whole column you want to format. To select a full column, use its letter heading.
On the Home tab, find the Number group and open its format menu.
Choose a suitable format, such as General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, or Text.
If needed, adjust decimal places or open Format Cells to set details such as negative-number display, date style, or a custom format.

Excel also provides a keyboard shortcut to open Format Cells on many Windows installations: Ctrl+1. On a Mac, the shortcut is typically Command+1. Shortcuts can depend on the operating system and keyboard, so use the menu if a shortcut behaves differently.

Apply a Format in Google Sheets

In Google Sheets on the web, select the cells and open the Format menu, then choose Number and select a format. The toolbar also provides shortcuts for common formats, including currency, percentage, and decimal-place adjustments. The available controls differ across desktop browsers and mobile apps.

Select the cells or range.
Open Format > Number, or use a relevant number-format button on the toolbar.
Choose a category such as Number, Percent, Currency, Date, Time, or Plain text.
For more control, use the custom date, time, or number format options where available.

A format applied to a selected range affects all cells in that range, including cells you fill in later if the formatting is part of the range. To copy a format without copying a cell’s value, use the app’s format-painting or paste-special formatting option when available.

Choose the Right Number Format

Pick a format that communicates what a value represents without implying a different value. A few common choices illustrate the difference:

Number: Useful for counts, measurements, and values where decimal places should be visible. You can usually choose how many decimal places to display.
Currency or Accounting: Useful for monetary values. These formats may show a currency symbol and handle alignment or negative values differently. Confirm that the selected currency matches the data.
Percentage: Displays a decimal multiplied by 100, usually with a percent sign. A stored value of 0.08 displays as 8%.
Date and time: Displays a date or time value in a chosen style. The underlying value is commonly represented numerically, even though the cell looks like a calendar date or clock time.
Text: Appropriate when content should remain a literal label or identifier rather than participate in numeric calculations. It is often useful for codes with leading zeroes.

Use a custom format when built-in choices do not show the value as needed. Custom formats can control decimal places, separators, symbols, and how positive, negative, zero, or text values appear. The syntax and supported options are not identical in every spreadsheet application, so check the app’s help or format dialog for its rules.

Common Problems and Misconceptions

Leading zeroes disappear. A value such as 00421 may display as 421 because numeric formats do not preserve insignificant leading zeroes by default. For identifiers, postal codes, or other codes, use a text format before entering the data, or apply a custom format that displays the required zeroes. A custom display does not necessarily make the value text; choose text when the identifier should not be used in arithmetic.

A date turns into a number. This usually means the cell is displaying the underlying date serial value in a general or numeric format. Apply a date format to display it as a calendar date. If the entry was imported as text, formatting alone may not convert it into a real date value; the data may need to be parsed or converted.

Percentages look 100 times too large. Percentage formatting scales the display. Entering 25 and applying Percentage commonly displays 2500%, because 25 is 25 times one, not 25 hundredths. To display 25%, the underlying value should be 0.25. Check whether a formula already multiplies by 100 before adding percentage formatting.

Changing decimal places seems to alter the answer. Displayed rounding and stored precision are not necessarily the same. A value stored as 1.236 may display as 1.24 while formulas still use 1.236. If a calculation truly must round, use a rounding formula; do not assume a display setting changes the stored value.

A number is left-aligned or will not calculate. Alignment can be a clue that the entry was interpreted as text, though it is not definitive because alignment can also be set manually. Check for leading apostrophes, spaces, import issues, or text-format settings, then convert the entry to a numeric value if arithmetic is intended.

Formatting, Conversion, and Rounding

Formatting changes appearance; conversion changes the kind or representation of the underlying data; rounding changes the numeric result. These actions are related but not interchangeable. For instance, changing a cell to display two decimal places does not necessarily round its stored value to two decimal places. Converting text such as “12.5” to a number can make it usable in a sum, while applying a Number format to text may leave it as text.

Regional settings can also affect interpretation. Depending on the spreadsheet’s locale, commas and periods may serve different roles in decimal and thousands separators, and date order may differ. When data is shared or imported, check the locale and verify a few representative cells before relying on the results.

Frequently Asked Questions

Does applying number format change the cell value?
Usually, no. It changes how the value is displayed. The underlying value remains available to formulas, except when a separate action converts or replaces the data.

How do I format a whole column?
Select the column heading, then choose the desired number format. New entries in the formatted column generally inherit that formatting, although behavior can depend on the spreadsheet and how data is added.

How do I keep leading zeroes?
For codes and identifiers, set the cells to Text or Plain text before entering or importing them. A custom number format can display leading zeroes while keeping a numeric value, but text is often better when the entry is not a quantity.

Why does 0.5 display as 50%?
That is the expected result for percentage formatting: the displayed percent is the stored decimal multiplied by 100. If you intended 0.5%, the stored value should be 0.005.

Can I copy formatting without copying data?
Yes. Use the format painter or a paste-special option that applies formats only, where available. These tools copy the visual or number-format settings without replacing the destination value.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.