Others

Excel Data Types and Supported Value Ranges: What Worksheet Cells Support

John WilsonJohn Wilson Nov 13, 2026 868 views

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.

Excel Data Types and Supported Value Ranges Explained
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.
Before you start

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.

Solution 1Recommended

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.

1
Select a result cell

Open your workbook in WPS Spreadsheets or Excel, and select an empty cell next to the value you want to check, such as B1.

2
Enter the TYPE formula

Type =TYPE(A1), replacing A1 with the cell reference that contains the value to test.

3
Press Enter and read the code

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.

4
Copy the formula as needed

Use the fill handle or copy and paste the formula to check additional cells in the worksheet.

Check worksheet cell data types with the TYPE function
Works in WPS Spreadsheets: The TYPE function is available in WPS Spreadsheets for common workbook values such as numbers, text, logical values, and errors.
Check data types in WPS Spreadsheets

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. 1. Download and install WPS Office: Go to the WPS Office website, download the free installer, and install WPS Office on your device.
  2. 2. Open WPS Spreadsheets: Launch WPS Office and click Spreadsheets to open a new workbook or an existing .xlsx file.
  3. 3. Enter sample values: Enter values such as 123, Hello, TRUE, and an error value in cells A1:A4.
  4. 4. Type the TYPE formula: Select B1, type =TYPE(A1), and press Enter to return the data type code.
  5. 5. Save the workbook in Excel format: Click Menu > Save As, choose .xlsx, and save the file so it remains ready for Microsoft Excel.
Uses the familiar TYPE function to identify Excel worksheet data typesOpens, edits, and saves .xlsx and .xlsm files while preserving workbook structureFree and lightweight Office suite with a familiar ribbon interfaceWorks with common Excel values including numbers, text, logical values, and errors
microsoft office alternative - wps office

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.