SharePoint Calculated Column Convert Text to Number

In this SharePoint tutorial, I will show you how to convert a text string that stores numbers to number values in SharePoint calculated column using the VALUE function.

The VALUE function converts numbers in a text format to number values. If a text or choice column has text characters instead of numbers, the values will not be displayed; It will show an error as #VALUE! in a calculated field.

The VALUE function also converts date and time formatted inputs that are equivalent “serial number” of date & time.

I have a SharePoint list named ‘Employee Information’ with a single line of text column with number strings i.e., Emp Serial Number.

Based on that column, I will show how to convert a text string with a number to a number value.

SharePoint Calculated Column Convert Text to Number

In this Section, I will show you how to convert a text string with a number to a number value. Follow the below instructions.

• Open a SharePoint list, and Click on +Add column -> Select See all column types and Click on Next.

• In the create column window, Give a name in a column name box and select datatype as Calculated(calculation based on other columns).

• And then, I applied the below-given formula to give an output.
• Select the data type returned from this calculated column as Number and Click Ok.

=VALUE([Emp Serial Number])

• Then it will create a calculated column (Serial Number Value) that converts text strings that represents a number to number values, as shown below:

• A text column with text characters instead of numbers will display an error as #VALUE!

This is about SharePoint calculated column convert text to number value.

Conclusion

Through this SharePoint tutorial, I explained how to convert a text string representing a number to number values by SharePoint calculated column.

You may also like:

• SharePoint Calculated Column Current Date
• SharePoint Calculated Column Remove Comma from Number
• SharePoint calculated column blank date
• SharePoint Calculated Column Convert Text to Number