The TEXTE function

The TEXTE (TEXT) function converts a value to text according to a specific format, for example a date in the "mmmm aaaa" format or a number with a thousands separator. The result is text, which can no longer be used as a number in calculations. It is mainly used to build dynamic labels.

Example

="Ventes de "&TEXTE(A1;"mmmm aaaa")

Related concepts

The whole glossary