Share via

iPad: cell properties

Anonymous
2023-07-22T22:27:22+00:00

Can’t find how to edit cell/column properties

E.g.: I have a column WEIGHT: “185 lbs”, “195 lbs”, ….

I have a column HEIGHT: 6’ 2”, etc.

Excel decided that HEIGHT was, in fact, a date and automatically converted it to June, 02

Can’t find any way tell excel how to format cells/columns data type, so that “lbs” is a descriptor and height is feet and inches

Btw, help (lightbulb) and Search (?) direct me to MSoft site which shows windows application stuff and “smart lookup” shows me pictures of Greek columns !

It must be in a menu somewhere. . .

???

Microsoft 365 and Office | Excel | For home | iOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-25T05:07:40+00:00

    Thanks - my question was only about data type.

    There is no “Data Type” under the Data tab after selecting a column.

    Only one of your references is regarding iPad, and if you were to look at that

    “ https://support.microsoft.com/en-us/office/excel-for-ipad-touch-guide-e7ca39ea-8fb1-43ed-8d98-d6200c385c1d “

    you would understand the uselessness of that webpage.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-07-23T00:03:56+00:00

    Hi,

    I'm Ajibola, an Independent Consultant here and a Microsoft user like you. I don't work for Microsoft and cannot access any of your data on their system.

    You can format cells in Excel on iPad in several ways. To format cells with bold, font color, or font size, select the cells and go to the ribbon to select changes. To apply Excel styles, select the cells and select Home > Cell Style and select a style. To format cells that contain text, number, or date or time values, use an icon set. To format only top or bottom ranked values, use an icon set. To format only values that are above or below average, use an icon set. To format only unique or duplicate values, use an icon set¹.

    To change the data type of a column in Excel on iPad, you can follow these steps:

    1. Select the column you want to change.
    2. Tap on the "Data" tab.
    3. Tap on "Data Type".
    4. Select the data type you want to apply to the column².

    I hope this helps! Let me know if you have any other questions.

    Reference : (1) Change the format of a cell - Microsoft Support. https://support.microsoft.com/en-us/office/change-the-format-of-a-cell-0a45ff85-ee24-4276-94e8-aed6083e8050. (2) Excel for iPad touch guide - Microsoft Support. https://support.microsoft.com/en-us/office/excel-for-ipad-touch-guide-e7ca39ea-8fb1-43ed-8d98-d6200c385c1d. (3) Set data type like number, text and date in excel column using .... https://stackoverflow.com/questions/13827709/set-data-type-like-number-text-and-date-in-excel-column-using-microsoft-office. (4) How to Format a Cell in Microsoft Excel: 5 Steps (with Pictures) - wikiHow. https://www.wikihow.com/Format-a-Cell-in-Microsoft-Excel. (5) Format an Excel table - Microsoft Support. https://support.microsoft.com/en-us/office/format-an-excel-table-6789619f-c889-495c-99c2-2f971c0e2370..

    Kind regards Ajibola

    0 comments