---
title: "_ColumnTypesXLCld"
canonical: "https://support.appfire.com/space/XL/2725183804/_ColumnTypesXLCld"
format: markdown
---
Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. When the default behavior is less than optimal for your situation, the C*olumn types* parameter can be set specifically. This page describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry. 

> ⚠️ The following column types are not supported in the current release:
> ⚠️ 
> ⚠️ - Numeric with data formatting (*FF*)
> ⚠️ - Float with comma as decimal point (*FC*)
> ⚠️ - Currency with comma as decimal points (*CC*)
> ⚠️ 
> ⚠️ These column types are expected to be featured in the upcoming release.

| **Type** | **Description** | **Sorting** | **Total Formatting** | **Data Formatting** |
| --- | --- | --- | --- | --- |
| **String (S)** | Text string. This is a series of one or more alphanumeric characters, possibly including a letter, number, space, punctuation mark or other special characters. | Alphabetic |  |  |
| **Integer (I)** | Integer. This is a numeric field without a fractional component. | Numeric | :check_mark: |  |
| **Numeric or float values (F)** | Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. | Numeric | :check_mark: |  |
| **Currency (C)** | Similar to **F** with more leniency on leading and trailing characters to allow currency and similar symbols to be present and ignored. | Numeric | :check_mark: |  |
| **Date (M)** | Date format in many popular formats. See [Advanced date sorting](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74813432) for more information. This is the preferred date sorting type. | Date |  | :check_mark: |
| **Date in the browser date format (D)** | Date in the browser date format. See [Advanced date sorting](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74813432) for more information. The **D** type is available for compatibility with older releases - the **M** type is recommended. | Date |  |  |
| **Complex HTML elements like emotions or similar (E)** | Emoticons or other HTML elements. | Alphabetic on the inner HTML value |  |  |
| **Exclude this column from user selectable sorting (X)** | Indicates to exclude this column from user selectable sorting. | Disabled |  |  |
| **.** | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '**.**'. | Numeric on each separated value |  |  |
| **:** | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '**:**'. | Numeric on each separated value |  |  |
| **-** | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '**-**'. | Numeric on each separated value |  |  |
| **/** | Separated numbers, like phone numbers or TCP addresses. Valid values are multiple integer numbers separated by '**/**'. | Numeric on each separated value |  |  |
| **Hide the column (H)** | Indicates to hide the column. |  |  |  |

- **Total formatting** - option to format the total row in a user defined way. See [Format the Auto Total Row for Numeric Columns](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74812448).
- **Numeric data formatting** - option to format the data rows in a user defined way for numeric columns. See [Formatting Options for Numeric Columns](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74813870).
- **Date data formatting** - option to format the data rows in a user defined way for date columns. See [Formatting Options for Date Columns](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74813568).