function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
srikanth sfdcsrikanth sfdc 

Changing text to number

Hi all,

I have a field in detail page which is text field 
and i want to write a  formule field so tht i have to change the text which is in tht text field to number as the return type in formule field is number


can any one please help out from this with syntax of changing the text value to number
KaranrajKaranraj
Hi Srikanth - You can able to convert text into number using formula Value(text)
Shyam BhundiaShyam Bhundia
best to check if the text is a number first, before you try to convert.  Try;
: 
IF( ISNUMBER(text__c), VALUE(text__c), 0)