How to format date displayed in Excel on iPad

Question

How do I format a date so it is displayed as mm/dd/yyy on iPad

Answer 1

Dear Wendy Jenkins

Welcome to Microsoft Community.

We understand that you want to set the date format of Excel in iPad.

According to your description, you mainly use Excel files in iPad, and need to set it to mm/dd/yyy format. We have tested and confirmed it, and need to explain to you:

It can also help to set the corresponding cell format and information in iPad, but some functions may be limited compared to Windows system.

Please make sure your Excel application is up to date. To set the date format to mm/dd/yyy, go to System Settings> General> Language and Region, and make sure your regional settings are correct (for example: US English)

Then you can select the cell range that needs to be filled in

In Excel, in "Home"-Format-Select "Date" to confirm (some pages may be directly displayed as General or Format, and some pages in iPad are icons with the letter "a")

or

• After selecting, you can fill in the information in the selected cell in the format of mm/dd/yyy to see if it can be filled in successfully.
• At the same time, if you need to change it later, you can also select other format information through the "Date" format and select the cell range, and the cells will change the format directly according to your selection.

You can try to see if it can help you set the format successfully. If there are other displays or other updates, you can reply to us and we will help you confirm further.

Best Regards, 

Zenobia.Z | Microsoft Community Support Specialist