Available Data Types

You can find a list of supported data types on the Data tab of the ribbon. The screen below shows the data types available in Excel 365 as of January 2022:

Using Data Types

To use Data Types, first enter values in one or more cells. These should be values Excel can recognize as potential Data Types. Then select one or more cells, and choose an appropriate data type from the options on the Data tab of the Ribbon:

Note: Excel may ask you to confirm specific values that have more than one possibility. Next, select or type the fields you want to display. This can be done by referencing a cell that contains a Data Type in a formula, as shown below:

Note the “dot” syntax used in the formula that separates the Data Type in cell B4 from the field name: Field names that include spaces must be wrapped in square brackets: You can also use the FIELDVALUE function to retrieve a field value from a Data Type: Note the field values available for a given data type vary according to the kind of information it represents. In the example above, we selected the “Geography” Data Type. Another option is to use the “Cities” Data Type. The fields available for each of these Data Types are different. Author

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Excel Data Type - 51Excel Data Type - 70