Articles with the tag:
Close
Changelog
Close
Try in the cloud
Try in the cloud

Change number format

You can easily change the number format, i.e. the way the numbers you enter appear in your spreadsheet. To do that,

  1. select a cell, a range of cells or the whole worksheet,
  2. open the Cell settings panel by
    • tapping the Edit object icon at the top toolbar, or
    • tapping the Cell option in the pop-up menu,
  3. tap the Open settings icon to the right of the Number format menu item Format section to open the Format panel.
  4. tap the number format you wish to apply:
    • General format General - is used to display the data you enter as plain numbers in the most compact way without any additional signs,
    • Number format 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 format Integer - is used to display the numbers as an integer,
    • Scientific format 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 format 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 Open settings 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 format 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 Open settings 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 format Date - is used to display dates. Tap the Open settings 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 format Time - is used to display time. Tap the Open settings 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 format Percentage - is used to display the data as a percentage accompanied by a percent sign %,
    • Text format Text - is used to display the numeric values as a plain text with as much precision as available.
Power up your iOS Create, edit and view documents, spreadsheets
and presentations of all popular formats
You Might Also Like This:
Close