---
title: "Use the TRUNC Function to Truncate Numbers to Specific Decimal Place"
slug: "trunc-function"
description: "Learn to use TRUNC to limit decimal digits in Pigment and simplify number formatting for cleaner data presentation."
updated: 2026-01-14T11:57:34Z
published: 2026-01-14T11:57:34Z
canonical: "kb.pigment.com/trunc-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.

# TRUNC function

## ​​​Description

Truncates a Number to only keep a given number of decimal digits.

## Syntax

`TRUNC(Number [, Number of Kept Digits])`

## Arguments

| Argument | Type | Dimensions | Description |
| --- | --- | --- | --- |
| *Number* (required) | Number | Any Dimensions | Number to truncate digits from. |
| *Number of Kept Digits* (optional) | Integer | No Dimension or Dimensions of argument *Number* | Number of digits to keep. By default, no digits are kept. |

## Returns

| Type | Dimensions |
| --- | --- |
| Number | Dimensions of argument *Number* |

`BLANK` if *Number of Kept Digits* is a negative integer.

## Examples

| Formula | Result | Description |
| --- | --- | --- |
| `TRUNC(2.365)` | 2 | All decimal digits from 2.365 are truncated. |
| `TRUNC(2.365, 1)` | 2.3 | Only one decimal digit from 2.365 is kept. |
| `TRUNC(1.11, -1)` | `BLANK` | The *Number of Kept Digits*, -1, is invalid. |

## Use case: conversion to integers with TRUNC

If you want to convert numerical data containing decimal digits from Number type to Integer type, you can use the following:

- [ROUND](/v1/docs/round-function)
- [ROUNDUP](/v1/docs/roundup-function)
- [ROUNDDOWN](/v1/docs/rounddown-function)
- TRUNC

By default, using any of the above with no second argument turns numbers with decimals into integers, compatible with Integer type. `ROUNDDOWN()` and `TRUNC()` return an integer with decimal digits removed.

## See also

Excel: [TRUNC](https://support.microsoft.com/en-us/office/trunc-function-8b86a64c-3127-43db-ba14-aa5ceb292721)

> [!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!