If you need to convert a number into a text number within a formula there are a couple of ways to achieve this, but one way is a lot easier.
Assume cell A1 has a number in it.
The formula that converts this real number into a text number is
The two quotation marks used together represent a blank in Excel.
The & symbol joins text strings together.
When you use the & in your formula the result is always treated as text.
We are joining the blank string to a number and the result is a text string of that number.