Jun 29, 2017 06:26 AM
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!
Jan 17, 2019 02:58 AM
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)
Jan 14, 2022 02:14 PM
Thank you so much, this works perfectly!
Nov 20, 2022 08:42 AM
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…