Monday, May 15, 2017

Format numbers in Excel Online

Format numbers in Excel Online

When you type numbers in your worksheet, Excel Online 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 Online 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

No comments:

Post a Comment