PlayInfoBox

Home /Utilities /How to Create a Custom Number Format in Excel

How to Create a Custom Number Format in Excel

Tap a step to see how it works.

  1. Select the cells to format

    Select the range of cells whose number display you want to change.

  2. Open the Format Cells dialog

    Press Ctrl+1, or right-click and choose Format Cells.

  3. Choose Custom under Category

    In the Number tab, click Custom.

  4. Enter a format code

    Type a format code such as #,##0 for thousand separators, or add a currency symbol like $#,##0 if you need one.

  5. Why this helps

    It lets you dress up how numbers are displayed exactly the way you want while leaving the underlying value untouched, making reports much easier to read.

Looking good on screen, accurate in calculations

If you want to add thousand separators or a currency symbol to a number without changing the actual value used in calculations, a custom format code solves exactly that problem β€” display and calculation stay completely separate.

Formatting rules vary by spreadsheet program

Format codes are broadly consistent across Excel and Google Sheets, but always double-check your specific currency symbol and separator conventions, since punctuation and symbol placement can vary from country to country.

Frequently Asked Questions

Can I show negative numbers in red?

Yes. Separating positive and negative formats with a semicolon, like "#,##0;[Red]-#,##0", displays only negative numbers in red.

Does applying a custom format change the underlying value?

No. Formatting only changes how a value is displayed on screen β€” it has no effect on the actual value stored in the cell or on any formula calculations.