Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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. Right-click anywhere in the highlighted cell range. On the shortcut menu, select the format that you want and then select OK.

    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.

    Currency option in Number format screen

    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. You can also use the pointer to drag the border, or right-click the header and use the shortcut menu that appears.

change the column width

More on formatting numbers

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!