---
schema_version: "1"
id: fcf5f12c13b22169c2ec7f439fe1504d3764b516d1fb8ecef8bdf130cf7adc1a
title: VALUE
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/customize_functions_value.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.customize_functions_value.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b41d89106227cba604bac7126d333572aa9f14fd8981331cfa98d0cc275f1b44
description: Converts a text string to a number.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# VALUE

Converts a text string to a number.

## Use

`VALUE(text)` and replace text with the field or expression you want converted into a number.

## Tips

Make sure the text in a VALUE function doesn’t include special characters other than a decimal point (period) or minus sign (dash). If the text in a VALUE function is a non-numerical/invalid format, the formula isn’t calculated and resolves to a blank value. For example, the formula `1 + VALUE(Text_field__c)` produces these results:

- If Text field is 123, the result is 124.
- If Text field is blank, the result is blank.
- If Text field is $123, the result is blank.
- If Text field is EUR123, the result is blank.

![Lead Number](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_example.png)

Lead Number

`VALUE(Lead_Number__c)` returns a number for the text value in the auto-number field Lead Number. This function is useful if you want to use the Lead Number field in a calculation. Note that auto-number fields are actually text fields and must be converted to a number for numeric calculations.

![Round Robin Lead Assignment](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_example.png)

Round Robin Lead Assignment `MOD(VALUE(Lead_Number__c), 3)`

This formula is for a custom formula field named Round\_Robin\_ID that assigns each lead a value of 0, 1, or 2. This formula uses a custom auto-number field called Lead Number that assigns each lead a unique number starting with 1. The MOD function divides the lead number by the number of lead queues available (three in this example) and returns a remainder of 0, 1, or 2. Use the value of this formula field in your lead assignment rules to assign lead records to different queues. For example:

- Round\_Robin\_ID = 0 is assigned to Queue A
- Round\_Robin\_ID = 1 is assigned to Queue B
- Round\_Robin\_ID = 2 is assigned to Queue C