Excel text function


I am looking for an Excel function that will change a "number" into a "text string"

12345 (number) will become '12345 (string)
111 (number one hundred and eleven) will become '111 (notice the ' before the 111)

Like if I wanted to add automatically a ' before the number

I hope anyone can understand my need

Thank you
Who is Participating?
Haris DjulicConnect With a Mentor Commented:
Use TEXT function under assumption that A1 has the number here is the formula to get to text

gadsadAuthor Commented:
Thank you it is perfect
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.