A
AL-B
If so how?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike
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.
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.
B
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)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
B
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)
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
D
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.
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.