Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I convert numbers to text in Excel?
If so how?
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I convert numbers to text in Excel?
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. "AL-B" wrote: If so how? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I convert numbers to text in Excel?
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) "AL-B" wrote in message ... If so how? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I convert numbers to text in Excel?
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) "AL-B" wrote in message ... If so how? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I convert numbers to text in Excel?
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. -- David Biddulph "Mike" wrote in message ... 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. "AL-B" wrote: If so how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Completely baffled on what should be simple | Excel Discussion (Misc queries) | |||
convert numbers stored as numbers to text | Excel Worksheet Functions | |||
Convert numbers stored as text to numbers Excel 2000 | Excel Discussion (Misc queries) | |||
convert numbers to text | Excel Discussion (Misc queries) |