Convert Number to Text

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”.


Hey there @mark1 :wave:

Welcome to the community, we are happy to see you here :pray: :partying_face:

You can do that by simply using our concatenate formula:

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 :v: