Converting a number to a text number in Excel

An easy formula

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.

Leave a Reply

Your email address will not be published. Required fields are marked *