Clean up text
Show a number with a format inside text
=TEXT(A2,"$#,##0.00")How it works in Excel
- A2 is the number.
- The part in quotes sets how it looks.
- The result is text, so you cannot do math on it afterward.
- It is useful for sentences, such as ="Total: "&TEXT(A2,"$#,##0.00").
The idea in general
It dresses a number up for display, the way you would write it on a sign.
What I assumed
- The number is in A2.
Check the result on your own data before relying on it.