---
title: "_ColumnTypes80"
canonical: "https://support.appfire.com/space/atdc/2945220635/_ColumnTypes80"
format: markdown
---
Column types determine how column data is sorted and displayed. By default, column data is treated as a text string sorted alphabetically. Some macros, like the *SQL* and *CSV* macros, may automatically generate more precise types. When the default behavior is less than optimal for your situation, the *columnTypes* parameter can be set specifically. This describes the behavior of the various types. In addition, numeric types are right aligned and can result in a total row entry.

Navigate to ***Column settings > Formatting > Column type*** in the respective macro to select from the list of available column types.

![Column types configuration in Advanced Tables for Confluence Data Center](media://ca16c4ef-c7e9-4e41-9609-0b63c612768b)

| **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: |  |
| **Numeric with data formatting (FF)** | Numeric or float value and may contain numeric separators including a decimal point and a comma for thousands separator. Forced formatting of data columns.<br>> ⚠️ If this column type is specified and the column contains any text or non-numeric value, this value is rendered as a zero (0). | Numeric | :check_mark: | ![image](media://048da3c2-a265-4dba-b52e-c9b31d5335ae) |
| **Float with comma as decimal point (FC)** | Numeric or float value and may contain numeric separators including a comma for decimal separator and a period 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: |  |
| **Currency with comma as decimal points (CC)** | Similar to **FC** 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/atdc/pages/2911506319) 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/atdc/pages/2911506319) 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/atdc/pages/2911503138).
- **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/atdc/pages/2911506262).
- **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/atdc/pages/2911506170).