What does the TEXT function do in Excel?

Microsoft Excel Medium

Microsoft Excel — Medium

What does the TEXT function do in Excel?

Key points

  • The TEXT function requires a format code to specify the desired text format.
  • It is often used to combine numbers with text in a single cell.
  • The function does not perform calculations on the converted text.
  • It is distinct from other functions that convert data types.

Ready to go further?

Related questions