How to begin converting Time String to Number or D...

[Elias_Gomez_Sai]

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!

[rendszerezz]

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)

[Melissa_Hanson1]

Thank you so much, this works perfectly!

[Matthew_Hoult]

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…