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.
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
Preeti Sahu is an expert in Power Apps and has more than 6 years of experience working with SharePoint and the Power Platform. As a Power Platform expert for Power BI, Power Apps, Power Automate, Power Virtual Agents, and Power Pages, she is currently employed with TSinfo Technologies. She is the author of the book Microsoft Power Platform A Deep Dive. She also made a big technical contribution to SharePointDotNet.com in the form of articles on the Power Platform. She enjoys traveling and spending time with her family in her spare time.