You can easily change the number format, i.e., the way the numbers you enter appear in your spreadsheet. To do that:
- Select a cell, a range of cells or the whole worksheet.
- Open the Cell settings panel by
- tapping the
icon at the top toolbar, or
- tapping the Cell option in the pop-up menu.
- Tap the icon to the right of the Format section to open the Format panel.
- Tap the number format you wish to apply:
- Custom format - is used to set a custom format for the cell. Tap the Create custom format button and enter the required format, then tap Done at the top right corner of the panel.
- General - is used to display the data you enter as plain numbers in the most compact way without any additional signs.
- Number - is used to display the numbers with 0-30 digits after the decimal point where a thousand separator is added between each group of three digits before the decimal point.
- Integer - is used to display the numbers as an integer.
- Scientific (exponential) - is used to keep short the numbers converting in a string of type d.dddE+ddd or d.dddE-ddd where each d is a digit 0 to 9.
- Accounting - is used to display monetary values with one of the following currency symbols: $ Dollar, € Euro, £ Pound, ₽ Rouble, ¥ Yen, and two decimal places. Tap the icon and select the necessary one. Unlike the Currency format, the Accounting format aligns currency symbols by the left side of the cell, represents zero values as dashes and displays negative values in parentheses.
- Currency - is used to display monetary values with one of the following currency symbols: $ Dollar, € Euro, £ Pound, ₽ Rouble, ¥ Yen, and two decimal places. Tap the icon and select the necessary one. Unlike the Accounting format, the Currency format places a currency symbol directly before the first digit and displays negative values with the negative sign (-).
- Date - is used to display dates. Tap the icon and select one of the following date formats: MM-dd-yy, MM-dd-yyyy, dd-MM-yy, dd-MM-yyyy, dd-MMM-yyyy, dd-MMM, MMM-yy.
- Time - is used to display time. Tap the icon and select one of the following time formats: HH:mm, HH:MM:ss, hh:mm tt, hh:mm:ss tt, [h]:mm:ss.
- Percentage - is used to display the data as a percentage accompanied by a percent sign %.
- Text - is used to display the numeric values as a plain text with as much precision as available.
- To clear the number formatting in a cell:
- tap the Edit icon in the top toolbar.
- tap the Clear menu item.
- choose the Format option.