How to Format Numbers in Excel for iOS (iPhone and iPad)

Excel has a comprehensive tool to help you to format numbers in a wide variety of ways. In this tutorial, you will learn how to find it and use it.

Step # 1 – Enter the “Home” menu

First, select the cell you would like to give a format. Depending on the device you are using to run Excel for iOS, you will have to perform or not additional steps to be able to format numbers automatically.

Find the ribbon button, and then look for the “Home” option.

Enter the Home menu

Step # 2 – Finding the Number Formatting option

Once you are inside the “Home” menu, you will realize there is an option called “Number formatting”. Again, you have to be sure of selecting previously the cell which content you are intending to format.

Finding the Number Formatting option

Once you click it, you will have access to a wide number of options to format numbers, such as Date, Currency, Fraction, Percentage, etc. If you click, for example, “Currency”, you will realize that a currency symbol will be automatically added to the number, and the format of the data corresponds with said category.

You can also further customize a specific format category. In order to do this, click in the “I” symbol at the right of your chosen category. Modifying these characteristics will impact immediately on how the data is formatted and displayed:

Modifying these characteristics