Formatting Data

You can apply the format of various data types to cells, including number, date, and currency. You can also format data with local settings or customize your own formats.

Formatting numbers, currencies, dates, or time

To apply a number, currency, date, or time format:

1. Select the cells that you want to format.
2. Click the Format button in the top menu or right-click on the selected cells to open the context menu > Data format, and select Number, Currency, Date, or Time.
3. Select the data type that you want to apply.
4. To remove the format, click the Format button in the top menu or right-click on the selected cells to open the context menu > Data format, and select Automatic.

Formatting with Locale Settings

Different languages and geographic regions have different ways for formatting numbers, currencies, and time-related data, which can be defined by choosing a locale for your spreadsheets. For the 20 languages supported by DSM, Office provides 68 locales for your choice. By selecting a locale, data can be presented in the conventional formats of your language and region.

To change the default locale for all spreadsheets:

1. Click the Account icon in the lower left corner on the screen.
2. Go to Settings > Office > Default locale.
3. The default locale will be the same as your browser locale. Select a locale from the drop-down menu to change the default locale.
4. Click OK.

To customize the locale for one particular spreadsheet:

1. In a spreadsheet, click the File button to open the drop-down menu > Spreadsheet settings.
2. Select a locale from the drop-down menu to change the locale for this spreadsheet.
3. Click OK.

Customizing formats of numbers, currencies, dates, or time

Once you have defined your data as a number, currency, date, or time, you may want to further adjust its detailed format. Follow the steps below to do so.

To customize a currency format:

1. Select the cells that you want to format.
2. Click the Format button in the top menu or right-click on the selected cells to open the context menu > Data format > More currency formats.
3. Select a currency from the list. You can also search for a currency via the search bar.
4. Open the drop-down menu to select and preview the format.
5. Click OK.

To customize a date or time format:

1. Select the cells that you want to format.
2. Click the Format button in the top menu or right-click on the selected cells to open the context menu > Data format > More date and time formats.
3. Select a date or time format from the list. The list displays the most frequently used formats in your locale.
4. Click OK.

To customize a number format:

1. Select the cells that you want to format.
2. Click the Format button in the top menu or right-click on the selected cells to open the context menu > Data format > Custom formats.
3. Select a number format from the list. You can also add your own number format by typing it into the text box on top.