Can I convert numbers to text in Excel?

[Guest]

If so how?

 

[Guest]

It depends what you mean on how you do it. Putting a comma in front of the
number (,10) turns it into text. The comma won't be displayed. If you want 10
shown as Ten then create a table and use Vlookup.

 

[Bob Phillips]

See http://xldynamic.com/source/xld.xlFAQ0004.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bob Phillips]

See http://xldynamic.com/source/xld.xlFAQ0004.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[David Biddulph]

If you precede a number by a comma, the comma *will* be displayed (or at
least it will in my version of Excel).
If you want a number in a cell to be formatted as text, precede it with an
*apostrophe*, which will *not* be shown.

If you have a cell containing a number, and you want it converting to text
(perhaps to maintain format while exporting to Word mail merge, for
example), then use the TEXT() function.