---
url: /cube-functions/numberformat.md
description: Returns the provided number formatted based on the given format.
---

# NUMBERFORMAT

Returns the provided number formatted based on the given format.

```js
NUMBERFORMAT(input_number, format)
```

#### Parameters

* `input_number` - The number to be processed.
* `format` - The format to use.

#### Examples

```js
NUMBERFORMAT(1234567.89, "#,##0.00")
```

**Result:** `1,234,567.89`

```js
NUMBERFORMAT(1234567.89, "#,##0.0")
```

**Result:** `1,234,567.9`

```js
NUMBERFORMAT(1234567.89, "#,##0.000")
```

**Result:** `1,234,567.890`

```js
NUMBERFORMAT(1234567.89, "#,##0.0000")
```

**Result:** `1,234,567.8900`

```js
NUMBERFORMAT(1234567.89, "#,##0.00000")
```

**Result:** `1,234,567.89000`

```js
NUMBERFORMAT(1234567.89, "#,##0")
```

**Result:** `1,234,568`

```js
NUMBERFORMAT(1234567.89, "#,##0k")
```

**Result:** `1,235k`

```js
NUMBERFORMAT(1234567.89, "#,##0.0k")
```

**Result:** `1,234.6k`

```js
NUMBERFORMAT(1234567.89, "#,##0.00k")
```

**Result:** `1,234.57k`

```js
NUMBERFORMAT(1234567.89, "#,##0.000k")
```

**Result:** `1,234.568k`

```js
NUMBERFORMAT(1234567.89, "#,##0m")
```

**Result:** `1m`

```js
NUMBERFORMAT(1234567.89, "#,##0.0m")
```

**Result:** `1.2m`

```js
NUMBERFORMAT(1234567.89, "#,##0.00m")
```

**Result:** `1.23m`

```js
NUMBERFORMAT(1234567.89, "#,##0.000m")
```

**Result:** `1.235m`

```js
NUMBERFORMAT(1234567890, "#,##0b")
```

**Result:** `1b`

```js
NUMBERFORMAT(1234567890, "#,##0.0b")
```

**Result:** `1.2b`

```js
NUMBERFORMAT(1234567890, "#,##0.00b")
```

**Result:** `1.23b`

```js
NUMBERFORMAT(1234567890, "#,##0.000b")
```

**Result:** `1.235b`

```js
NUMBERFORMAT(0.123, "0.000%")
```

**Result:** `12.300%`

```js
NUMBERFORMAT(0.123, "0.00%")
```

**Result:** `12.30%`

```js
NUMBERFORMAT(0.123, "0.0%")
```

**Result:** `12.3%`

```js
NUMBERFORMAT(0.123, "0%")
```

**Result:** `12%`