Excel Data Types and Supported Value Ranges: What Worksheet Cells Support
Question details
User needs to know which data types Excel worksheet cells expose and their supported value ranges, and how programming types such as int8, uint32, or UTF-8 relate to Excel.

- Product
- WPS Spreadsheets / Microsoft Excel
- Device & OS
- not provided
- Scenario
- Understanding cell data types and value ranges when entering, checking, or importing data in Excel-compatible worksheets.
- Observed behavior
- Worksheet cells expose six data types through the TYPE function; integer sizes, unsigned integers, and text encodings such as UTF-8 are programming or data-import concepts rather than separate worksheet cell types.
Open the workbook in WPS Spreadsheets or Excel, and make sure the values you want to check are entered in worksheet cells rather than only processed through VBA or Power Query.
Check worksheet cell data types with the TYPE function
Use this when you need to identify the worksheet data type of cell values in WPS Spreadsheets or Excel.
The TYPE function returns a numeric code for the value in a referenced cell. It does not show programming types such as int8 or uint32; those belong to VBA, Power Query, or import environments.
Open your workbook in WPS Spreadsheets or Excel, and select an empty cell next to the value you want to check, such as B1.
Type =TYPE(A1), replacing A1 with the cell reference that contains the value to test.
Press Enter. Use the returned code: 1 for number, 2 for text, 4 for logical value, 16 for error, 64 for array, and 128 for compound data in Microsoft 365.
Use the fill handle or copy and paste the formula to check additional cells in the worksheet.

Separate worksheet data types from programming data types
Use this to avoid confusion when your data is processed through VBA, Power Query, or another import tool.
Use the TYPE Function in WPS Spreadsheets to Check Excel Data Types
WPS Spreadsheets supports Excel-compatible worksheet formulas, including the TYPE function, so you can check whether a cell value is a number, text, logical value, error, array, or compound data type without changing your Excel workflow.
- 1. Download and install WPS Office: Go to the WPS Office website, download the free installer, and install WPS Office on your device.
- 2. Open WPS Spreadsheets: Launch WPS Office and click Spreadsheets to open a new workbook or an existing .xlsx file.
- 3. Enter sample values: Enter values such as 123, Hello, TRUE, and an error value in cells A1:A4.
- 4. Type the TYPE formula: Select B1, type =TYPE(A1), and press Enter to return the data type code.
- 5. Save the workbook in Excel format: Click Menu > Save As, choose .xlsx, and save the file so it remains ready for Microsoft Excel.

Frequently Asked Questions
What are the six Excel worksheet data types returned by TYPE?
The TYPE function can return 1 for number, 2 for text, 4 for logical value, 16 for error, 64 for array, and 128 for compound data in Microsoft 365.
Does an Excel worksheet cell have an int8 or uint32 data type?
No. Integer sizes such as int8 and uint32 are programming and data-import data types used in VBA, Power Query, or other tools, not separate worksheet cell types.
Can I use the TYPE function in WPS Spreadsheets?
Yes. WPS Spreadsheets supports the TYPE formula for common Excel-compatible values, so you can enter =TYPE(A1) and read the returned data type code.
What does the TYPE function return for text and error values?
It returns 2 for text values and 16 for error values when the referenced cell contains those worksheet values.
Are UTF-8 text encodings shown as Excel cell data types?
No. UTF-8 and similar encodings are text handling and import settings, not a separate worksheet cell data type.




