Format dates, currency, and more in Pages on iPad

By default, Pages formats table cells automatically, so letter and numbers appear the way you type them. If you change the data format for a cell, you can always revert back to the automatic format.

1. Go to the Pages app on your iPad.

2. Open a document with a table, select the cells or table you want to format, tap , then tap Format.

3. Tap Automatic.

By default, cells formatted as numbers display as many decimal places as you type in them. You can change this setting so that all cells formatted as numbers display the same number of decimal places.

Changes to decimal settings apply to both numbers and percentages. For example, if you change a number in a cell to a percentage, the number of decimal places displayed doesn’t change.

1. Go to the Pages app on your iPad.

2. Open a document with a table, select the cells or table you want to format, tap , then tap Format.

3. Tap to the right of Number, tap a format (Number, Scientific, or Fraction), then set the number of decimal places and other display options.

By default, cells formatted as currency display two decimal places. You can change this setting so that cells display as many decimal places as you type in them, or so that all cells display the same number of decimal places.

1. Go to the Pages app on your iPad.

2. Open a document with a table, select the cells or table you want to format, tap , then tap Format.

3. Tap to the right of Currency.

4. To modify how many decimal places show, do one of the following:

   • Display as many decimal places as you type in each cell: Tap  until you reach the Auto setting.

   • Increase or decrease the number of decimal places displayed: Tap  next to Decimals.

5. To show the thousands separator, turn on Thousands Separator.

6. To display negative values within parentheses, turn on Accounting Style; to select a different display style, tap a red or black option.

7. To select a currency symbol, tap Currency, then tap the symbol you want.

By default, cells formatted as percentages display as many decimal places as you type in them. You can change this setting so that all cells display the same number of decimal places.

Changes to decimal settings apply to both percentages and numbers in a selected range of cells. For example, if you change the format of a cell from a percentage to a decimal, the number of decimal places displayed doesn’t change.

1. Go to the Pages app on your iPad.

2. Open a document with a table, select the cells or table you want to format, tap , then tap Format.

3. Tap to the right of Percentage.

4. Do one of the following:

   • Display as many decimal places as you type in each cell: Tap until you reach the Auto setting.

   • Increase or decrease the number of decimal places displayed: Tap next to Decimals.

5. To show the thousands separator, turn on Thousands Separator.

6. To select how negative values are displayed, tap a red or black option.

If you format a cell that already contains a value, the value is assumed to be a decimal and is converted to a percentage. For example, 3 becomes 300%.

1. Go to the Pages app on your iPad.

2. Open a document with a table, select the cells or table you want to format, tap , then tap Format.

3. Tap to the right of Date & Time.

4. Tap the options that match the display formats you want for Date and Time.

   If you tap None, no date or time is displayed in the cell, even if a date or time was entered and used in calculations.

   The date and time options depend on your device’s Date & Time settings.

If you don’t enter both a date and a time, Pages adds a default value for you. For example, if you type “1:15 PM,” Pages adds today’s date by default.

By default, cells containing duration data are automatically formatted to display all the time units you enter. You can change this setting so that duration cells display only certain units of time (for example, only hours, not minutes, seconds, or milliseconds), even though more precise duration values have been entered in the cell and are used in formulas that make calculations based on units of time.

1. Go to the Pages app on your iPad.

2. Open a document with a table, select the cells or table you want to format, tap , then tap Format.

3. Tap to the right of Duration.

4. To show or hide time unit labels, tap an option below Format:

   • None: Hides all time unit labels.

   • Short: Displays time unit labels as abbreviations—for example, “m” for minutes.

   • Long: Displays time unit labels fully spelled out.

5. To display the same kinds of units, turn off Automatic Units.

   A range selector appears.

   

6. Drag the left or right end of the range selector to encompass the time duration you want to use, from weeks (Wk) to milliseconds (Ms).

If you change the duration format after you enter data in the cells, the data automatically adjusts to the new duration format you set.