It's useful in situations where you want to display numbers in a more readable format, or you want to combine numbers with text or symbols. Note: The TEXT function converts numbers to text, which may make it difficult to reference in later calculations.