You can format numbers in a spreadsheet in a variety of ways, including decimal, percent, and scientific notation. You can also select different date formats and currencies to correctly display the data in your spreadsheet.
To format or change the format of numbers, dates or currencies in a spreadsheet, follow these steps:
- Select the range of cells you'd like to format or modify.
- Click the 123 toolbar icon.
- Select the number, date, or currency format you'd like to apply to the range of cells.