---
title: "Use the VALUE Function to Convert Text Numbers into Numbers"
slug: "value-function"
description: "Learn to use the VALUE function in Pigment to transform text representing numbers into numerical values."
updated: 2025-05-30T09:42:21Z
published: 2025-08-22T10:57:28Z
canonical: "kb.pigment.com/value-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.

# VALUE function

## Description

Converts a Text representing a number to a Number.

## Syntax

`VALUE(Text to Convert)`

> [!TIP]
> **Note:** `NUMBER` is an alias to the `VALUE` function. It can be used this way: `NUMBER(Text to Convert)`

## Arguments

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

## Returns

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

`BLANK` if *Text to Convert* is invalid or `BLANK`

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `VALUE(“32”)` | 32 |  |
| `VALUE(“-44.23”)` | -44.23 | Negative and decimal numberes are converted. |
| `VALUE(“a”)` | `BLANK` | “a” is not a valid number. |
| `VALUE(‘MyList’.Name)` |  | `MyList` is a List containing: |

## See also

Excel: [VALUE](https://support.microsoft.com/en-us/office/value-function-257d0108-07dc-437d-ae1c-bc2d3953d8c2)

Related articles: [TEXT](/v1/docs/text-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>