Format numbers in Excel for the web

When you type numbers in your worksheet, Excel for the web automatically applies the General number format but you can change this to show specific number formats like dates, currency, or even fractions.

For example, if you’re working on your quarterly budget, you can use the Currency number format to show your numbers as monetary values. You can set dates to display either as a long date like Saturday, December 14, 2013 or a short date 12/14/13. Here’s how:

  1. Select the column, or cells you want to format.

  2. Click Number Format and pick the format you want.

    Note: By applying a number format you are only changing how the number is shown and not the actual cell values that Excel for the web uses for calculations.

    Available number formats

    Tip: If some numbers appear as #####, it’s probably because the cell isn’t wide enough. To auto fit the numbers, double-click the right border of the column header.

change the column width

More on formatting numbers

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.