Is there a formula to convert numbers to text?
Trying to create concatenate the year component of 2 dates into a text “range” eg. “2020-2021”.
Thanks.
Hey there @mark1 
Welcome to the community, we are happy to see you here 
You can do that by simply using our concatenate formula:
Syntax:
CONCATENATE(YEAR(start date), " - ", YEAR(end date))
start date = date attribute number 1
end date = date attribute number 2
If you click on “formatting”, you will also be able to check / set if the result is in “text” format, “number” format or “date” format! If you decide to change it to number or date format - you will probably end up with a result you never expected.
In excel there’s a formula called “TEXT”, which converts any value to a text format, but - unfortunately - we do not have that formula in Infinity!
Hope that helps @mark1 