Can numbers as TEXT be turned into a NUMBER value?


I got a TEXT excerpt (having only numbers) extracted from a larger Text and I want to turn/use it as a number.

Is there a Function available to do this?


Best Answer

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭
    Answer ✓

    Try the VALUE function. Any numbers inserted as text (0001 for example) will be changed to their numerical value (1). You can wrap the value function around the formula you are using to extract the numerals from the text field.


    Blue 462

    Using =RIGHT(text@row, 3) would get you '462 (the apostrophe indicates text.)

    =VALUE(RIGHT(text@row, 3)) turns '462 text value to 462 numeric value, which then can be summed, etc.


    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!