Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to convert a number to a string?

25199 12
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a Formula field that gives me a number. How can I convert it to a String text? I have viewed the entire reference article but I don’t find it.

Thanks!

12 Replies 12

If the number’s lenght is 7, the middle part should start from 2 to have the right number:

MID(CONCATENATE({Final Sales},""),2,3)

Thank you so much, this works perfectly!

What if you have 8 and 9 figures?

Also I’m trying to create ‘Min Budget to Max Budget’ so its ‘90,000,000 to 100,000,000’

I’ve been using CONCATENATE({Min Budget}, " - ", {Max Budget},)

I can just replace your {final sales} with ‘{Min Budget}, " - ", {Max Budget}’ I’m hoping…