General in Excel: Find and Use the Number Format Setting

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, find General on the Home tab, in the Number group: select a cell, open the number-format drop-down, and choose General. General is Excel’s standard number format; it usually displays a value without adding a fixed number of decimal places, a currency symbol, or a date style.

Where to find General on the ribbon

Look near the middle of the Home tab for the Number group. Its number-format box displays the format currently applied to the active cell or selection. For a cell using General, the box normally reads General. Click the box’s drop-down arrow to see choices such as Number, Currency, Short Date, Long Date, Percentage, and Text, as well as General. Select General to apply it.

If the ribbon is narrow, Excel may compress parts of the group, but the number-format control is still associated with Number. Maximizing the Excel window or widening the app can make the group easier to spot. If the ribbon is hidden, show it first; the precise display controls can vary with the ribbon setting, but the Home tab is where the number-format control is located.

You can also open the Format Cells dialog for more format choices. On Windows, press Ctrl+1 after selecting a cell, then open the Number tab and choose General from the category list. On Excel for Mac, Command+1 opens Format Cells; the ribbon’s Home tab also has a number-format drop-down. In Excel for the web, use the Home tab’s number-format control and select General; desktop keyboard shortcuts may differ in a browser or be intercepted by the browser.

What the General format means

General is Excel’s usual default number format for cells in a new worksheet. It is not a promise that every value will appear exactly as typed, nor is it a command to treat every entry as a number. Excel interprets what you enter, stores a value or text, and then displays it according to the cell’s formatting and the available column width. The format is only one part of that process.

For ordinary numeric values, General typically shows as many digits as fit and does not force trailing zeros. For example, a stored value of 12.5 does not become 12.50 just because the cell is General. General also does not add a currency symbol or percent sign. Text is displayed as text, while a value Excel has recognized and stored as a date may be displayed using a date format instead.

General concerns presentation, not the mathematical meaning of the value. A cell displaying 12.5 can still be used in arithmetic, and changing its appearance to Number or Currency normally does not change the stored numeric value. However, how Excel interprets an entry when it is typed or pasted can affect what is stored. This distinction matters especially for dates, percentages, and long identifiers.

How to apply General to one cell or a range

To change the format, select the cell or cells first. A selection can include a continuous range, several nonadjacent cells, or an entire column if you select its column heading. Then choose General from Home > Number’s format drop-down. The selection’s appearance may change immediately, but its underlying values are not ordinarily recalculated just because you selected a different number format.

  1. Select the cell, range, row, or column you want to format.
  2. On the Home tab, locate the Number group and open the number-format drop-down.
  3. Choose General and check that the format box now displays General for the active cell.
  4. Review any changed display, especially dates, long numbers, or values that seem to lose zeros.

For a whole worksheet, click the Select All button at the intersection of the row and column headings, then apply General. This changes the format of the selected cells, not their contents. Existing values that were stored as text remain text; choosing General does not automatically convert every text value into a number. Likewise, cells with formulas still contain formulas, though their displayed results can look different.

Why a General cell may display differently than expected

General is flexible, so Excel may choose a compact display instead of preserving a particular number of decimal places. A narrow column can show number signs for some formatted values, or cause a number in General to appear in scientific notation. Widening the column can reveal more of the display, but it does not change the stored value. Use a deliberate format when the number of visible decimal places or the presentation is important.

Input interpretation is another source of confusion. If you type something Excel recognizes as a date, such as a date written with slashes, Excel may interpret it as a date and apply a date display. Which date an ambiguous entry represents can depend on regional settings. A value such as 25% may be interpreted as a percentage entry, while typing 25 and later applying Percentage displays it as 2,500%. These results reflect how Excel interprets the entry and the selected format, not a special hidden meaning of General.

Leading zeros are particularly important. If you enter 007 in a General cell, Excel typically treats it as the number 7, so the leading zeros are not retained as part of that numeric value. If the zeros identify a product code, postal code, or other label, store the entry as text or use a suitable custom display format when appropriate. A numeric format cannot make an identifier behave like a number while preserving every text-like feature automatically.

General compared with other number formats

Choose General when you want ordinary values to display without a fixed style and do not need a consistent number of decimal places. Choose Number when you want a predictable number of decimal places or a thousands separator. Choose Currency or Accounting for monetary presentation, Percentage for ratios you want displayed as percentages, and a date format for calendar values. These formats change presentation; they do not substitute for checking the underlying value.

For example, if a cell contains the numeric value 0.25, General may display 0.25, while Percentage displays 25%. Applying Percentage does not turn 0.25 into a different underlying number: it changes how that number is shown. Conversely, entering 25 and then applying Percentage gives a display of 2,500%, because Excel formats 25 as 25 multiplied by 100 for percentage display.

Text is different from General. Text formatting is useful when entries must remain labels or exact character sequences, such as codes with leading zeros. Applying Text before entering or pasting data helps Excel keep new entries as text. If a value has already been converted to a number, changing the cell to Text afterward cannot recover characters that Excel discarded, such as leading zeros or digits beyond its numeric precision.

Common problems and how to fix them

If the number-format box says General but the value still looks wrong, first check the column width and the cell’s actual contents. Select the cell and look at the formula bar to see the stored value or formula. If it contains a leading apostrophe or is left-aligned like text, the entry may be text rather than a numeric value. Choosing General changes the format but does not necessarily convert text to a number.

  • A date appears instead of a number: Excel may have interpreted the input as a date. Select a suitable number format to display its serial value, or re-enter the intended content in a way that Excel treats as text if it is a label.
  • Zeros at the start have disappeared: the entry was likely stored as a number. For future entries, format the destination as Text before typing or pasting, or use an appropriate custom format if the value should remain numeric.
  • A long number looks rounded or changed: Excel’s numeric storage keeps up to 15 significant digits. Long account-like IDs should generally be stored as text from the outset; changing the format later cannot restore digits already lost.
  • The format changes back or differs across cells: check whether you selected every relevant cell, whether a table or template applies formatting, and whether pasted cells brought formatting with them. Format Painter or Paste Special options can also affect what formatting is carried over.

For a value that should be numeric but is stored as text, you may need to convert the data rather than merely select General. Depending on the situation, Excel may offer a warning icon with a conversion option, or you can use a data-conversion method appropriate to the cells. Check a sample and preserve a copy before converting important imported data, because text can contain codes that should not become numbers.

How to decide whether General is the right choice

Use General for calculations and mixed everyday data when Excel’s flexible display is acceptable. Use a more specific number format when readers need consistent precision, clear units, or a standard presentation. A worksheet of prices is usually easier to read with a currency format; measurements often benefit from a chosen number of decimal places; a column of dates should use a date format that is unambiguous for its audience.

Before changing a column to General, ask what the values represent. A quantity such as 18 can be a number, but an item code such as 0018 may be an identifier whose exact characters matter. A phone number is also generally a label, not a quantity to calculate. Storing identifiers as text avoids arithmetic-oriented behavior and helps preserve formatting details such as leading zeros.

For shared workbooks, explicit formatting can make the sheet more reliable for other people. General is a reasonable default, but it leaves more of the display to Excel and the current column width. A deliberately chosen format communicates how a value should be read and can prevent readers from mistaking a ratio for a percentage or a code for a quantity.

Frequently Asked Questions

Is General the default format in Excel?
General is the standard default number format for cells in a new worksheet, unless a workbook, template, table, or user action supplies a different format. A particular cell may therefore not use General even though it is a common starting format.

Does changing a cell to General change its value?
Usually, changing the number format changes how a stored value is displayed, not the value used in calculations. But it does not undo Excel’s earlier interpretation of an entry, restore removed leading zeros, or recover digits lost from an overlong numeric entry.

How do I get General back in Excel?
Select the cells, open the number-format drop-down on Home in the Number group, and choose General. You can also use Ctrl+1 on Windows or Command+1 on Mac to open Format Cells and choose General on the Number tab.

Why does General show a number in scientific notation?
General may use scientific notation when a number is very large or small, or when the available display space is limited. Widen the column to see whether the presentation changes. If you need a particular display, choose an explicit number format, while remembering that formatting does not increase Excel’s numeric precision.

Will General keep leading zeros?
Not when Excel treats the entry as a number: numeric value 007 is ordinarily stored as 7. To preserve zeros as part of an identifier, enter or import it as text, ideally setting the cells to Text before entry, or use a custom number format when a numeric value is genuinely required.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.