# Display

The **Display** section allows you to specify how the column header and their values should be displayed based on your needs.

Go to **Setup > Columns**.

![Accessing the 'Columns' section](/files/1c459a4dea1a56f245d4676d56dad83a5896f0a1)

Click on the pencil icon beside the column name or double-click on the column name. Go to the **Display** tab.

![Display properties](/files/554952d6f20bf8e62ba68ced5b266249d141c767)

Here, you can add and configure various display properties, such as the date format, display name, thousand separator, prefix, and suffix.

### 1. Format

Using the Format property, you can define how the date and date-time values should be presented in the columns. You can choose from various date and date-time formats such as `MM/DD/YYYY`, `DD/MM/YYYY`, `DD MMM, YYYY hh:mm:ss`, and so on.

![Date format](/files/fc52e978fd6075e77315feaeeeabadff2bf10af9)

### 2. Display Name

The Display Name property enables you to display a user-friendly name for the column header, different from the actual field name in the database. For instance, the `ProductSubcategoryKey` field in the database can be displayed as `Product SubCategory` in the visual for enhanced clarity.

![Display Name](/files/ef4b45280878cd3f444cdadbef595777a4ac3470)

### 3. Description

You can use the `Description` field to include additional information in the column headers, helping users understand the data better. An `i` icon is added beside the header name, and when you hover over it, the additional description is shown.

![Description](/files/8911b93a13f9a672dc5cbea7e56541a73df3eddf)

### 4. Thousand Separator

By default, numbers in the column are displayed continuously without any thousand separators. To enhance the readability of large numeric values, you can add a comma, a period, or a space as a separator for every group of thousands.

![Thousand separator](/files/218c573c647408490c86c6f71bf46f113778a57b)

### 5. Prefix

This property allows you to add a prefix of up to two characters before numeric or decimal column values. This is commonly used to indicate currency symbols.

![Prefix](/files/342c726ecd202c9ebe5525bf631c687999b150f5)

### 6. Suffix

This property lets you add a suffix of up to two characters after numeric or decimal column values. This can be used to indicate measurement units like kilograms, centimeters, and percentages.

We have now discussed all the column properties that can be configured from the **Columns** section. In the next section, we will look at other options, such as importing/exporting configurations and adding columns.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/powertable-sheets/how-tos/configure-column-properties/display.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.