# VALUE

The **VALUE** function converts a text string that represents a number to a number.

### Syntax

```javascript
value(value:string)
```

### Arguments

value - A text string containing a number. Required.

### Example

```javascript
value(MID"ABC-123-WEW",5,3))
//Returns “123” as a number
```

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fdg4Zd3lU2S02k92oP8Bj%2Fimage.png?alt=media&#x26;token=0d0dd6f2-d200-4db7-8006-7d5d261c978d" alt=""><figcaption><p>Value function</p></figcaption></figure>

### **Excel equivalent**

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