However, there are situations where converting numbers to text makes sense.
One example is when you want toconcatenate(join) a formatted number to text.
Without the TEXT function, the number formatting will be stripped.
Convert with formatting
TheTEXT functioncan be used to convert numbers to text using a givennumber format.
Notice the output from the TEXT function is a text value, which is left-aligned by default in Excel.
in a text string with the number format of your choice.
