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
=""&A1
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.
You can tell the entry is cell B1 is text as it is left aligned.
Please note: I reserve the right to delete comments that are offensive or off-topic.