---
title: "Use the TEXT Function to Convert Numbers to Text in Pigment"
slug: "text-function"
description: "Learn to use the TEXT function to convert numbers or integers into text in Pigment for better formatting and reporting flexibility."
updated: 2025-05-30T09:41:10Z
published: 2025-08-22T10:57:28Z
canonical: "kb.pigment.com/text-function"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# TEXT function

## ​Description

Converts a Number or Integer to a Text.

## Syntax

`TEXT(Value to Convert)`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Value to Convert* (required) | Number or Integer | Any Dimensions | Value to convert to a Text. |

## Returns

| Type | Dimensions |
| --- | --- |
| Text | Dimensions of *Value to Convert* |

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `TEXT(32)` | “32” | The Integer 32 is converted to its corresponding Text. |
| `TEXT(-44.23)` | “-44.23” |  |

## See also

Excel: [TEXT](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)

Related articles: [VALUE](/v1/docs/value-function)

> [!TIP]
> More of a hands-on learner?
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!

<style> p[data-block-id] {font-size:1rem;} ul li p[data-block-id] {margin-bottom: 0;} ul[data-type="taskList"] li div p[data-block-id] {margin-bottom: 0;} ol li p[data-block-id] {margin-bottom: 0;} table tbody th p[data-block-id] { margin-bottom: 0;} blockquote p[data-block-id] {margin-bottom: 0 !important;} &nbsp;p[data-block-id]:empty::after {content: "\00A0";} </style>