Re: How to convert a number to a string?

7440 0
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.


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…