How to Format Numbers in Excel for iPhone

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.

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/103440382717658277879 - our group in Google+

Also check an iPad version:
https://youtu.be/CT3Ai84Q9hI

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 iPhone, 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.

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.

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.