From there, you’ll need to use the formula: VALUE (TextField1__c) From the docs: Description: Converts a text string to a number. Use: VALUE (text) and replace text with the field or expression you want converted into a number.
Table of Contents
How to convert text data to number in Excel?
Write a formula VALUE (field__c). This will convert text data stored in field__c into a number. Not sure there is a formula to take numbers like 12345 and turn them into 12,123 unless there is a set conversion factor. For straight text to number Rohit has the answer
What does it mean when a text cannot be converted to numbers?
That generally means the text being passed in can’t be converted to a number (does it contain something other than numbers such as letters, spaces or punctuation?). If you provide an example of the text and the formula I may be able to provide a little more specific suggestion, but make sure you are trimming white space and not passing colons etc.
How do I add multiple values to a text field?
If you are dealing with multiple values you could use a master detail custom object to have fields for both the description and the quantity separately and use a rollup field to add, subtract, etc. rather than placing all the data in a text field. 1.
How many characters can I add to the formula?
This formula can only handle up to “999” though. You can adjust this ’til Millions or whatever, just add some lines and tweak it. Just be reminded that if you add characters it might hit the character limit of the formula.