# Number Format Editor

## Overview

The **Number Format Editor** allows displaying any number (including user input) with a specific format automatically based on how the format is configured in Design time.

<figure><img src="/files/nsWTuH9uYO840BK8W1ok" alt=""><figcaption><p>Number Format Editor</p></figcaption></figure>

It can be used in any place where there is a `format` property:

* Form components like Textbox[^1], Typeahead[^2], Combobox[^3], [Data Label](#user-content-fn-4)[^4]
* Date Columns in the [Table Editor](#user-content-fn-5)[^5]
* Date Columns in Grid components like [Data Grid](#user-content-fn-6)[^6], [Power Grid](#user-content-fn-7)[^7], Table[^8]

## Sections

### UI Converter

It's located at the top of the editor and it allows modifying the value before applying the format to display and before storing the value in the data provider.

<figure><img src="/files/or4mhi3Vq9JPS6zlCqEQ" alt=""><figcaption><p>Use UI Converter option</p></figcaption></figure>

### Format Options

There are three options:

* Display Format
* Edit Format
* Max length

The first two allow entering any pattern. You may choose also from one of the predefined pattern in the drop down list. The third one place a limit on the maximum number of digits allowed.

### Legend

This is a helper list with all the special characters that can be used to define the pattern in the *Display Format* and *Edit Format*

[^1]: Guide for using a [Textbox](/guides/develop/application-design/ui-components/input-controls/textbox.md) in your applications

[^2]: A [Typeahead](/guides/develop/application-design/ui-components/input-controls/typeahead.md) is a text field that offers values from a provided value list, filtering the list as the user starts typing.

[^3]: Guide for using a [Combobox](/guides/develop/application-design/ui-components/input-controls/combobox.md) in your applications

[^4]: A [Data Label](/guides/develop/application-design/ui-components/buttons-and-text/data-label.md) is a label that can show dynamic text and possibly an image

[^5]: The reference documentation for the [Table Editor](/reference/servoy-developer/object-editors/table-editor.md)

[^6]: A [Data Grid](/guides/develop/application-design/ui-components/grids/data-grid_new.md) is a table providing advanced functionalities such as row grouping for the given foundset

[^7]: A [Power Grid](/guides/develop/application-design/ui-components/grids/power-grid.md) is a table component providing advanced functionalities such as row grouping and pivoting

[^8]: A [Servoy Extra Table](/guides/develop/application-design/ui-components/grids/table.md) is a lightweight read-only table


---

# 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.servoy.com/reference/servoy-developer/object-editors/number-format-editor.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.