| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to convert number to text ?
Dear Sir,
The number in text format is normally denoted by a ' before it. Eg. '62417, '47125 etc. Let say I have a clumn of numbers, may I know how to convert it into text format ? i.e. A B 1 2145 '2145 2 3621 '3621 3 6147 '6147 What formula must I input at B1 and copy down to get the answer ? Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to convert number to text ?
Hi
The easiest way would be Select column ADataText to ColumnsNextNextColumn Data formatTextFinish or by formula it would be ="'"&A1 Copy down as far as required. Copy column BPaste SpecialValues -- Regards Roger Govier "Mr. Low" wrote in message ... Dear Sir, The number in text format is normally denoted by a ' before it. Eg. '62417, '47125 etc. Let say I have a clumn of numbers, may I know how to convert it into text format ? i.e. A B 1 2145 '2145 2 3621 '3621 3 6147 '6147 What formula must I input at B1 and copy down to get the answer ? Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to convert number to text ?
Put this in B1 to turn the number to text:
=""&A1 and copy down. You can fix the values by highlighting column B, then <copy, Edit | Paste Special | Values (check) | OK | <Esc Hope this helps. Pete On Feb 29, 1:11*pm, Mr. Low wrote: Dear Sir, The number in text format is normally denoted by a ' before it. Eg. '62417, '47125 etc. Let say I have a clumn of numbers, may I know how to convert it into text format ? i.e. * * * * *A * * * * * * B 1 * *2145 * * * '2145 2 * *3621 * * * '3621 3 * *6147 * * * '6147 What formula must I input at B1 and copy down to get the answer ? Thanks Low -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to convert number to text ?
And if you always wanted 6 digits in your text string:
=text(a1,"000000") Mr. Low wrote: Dear Sir, The number in text format is normally denoted by a ' before it. Eg. '62417, '47125 etc. Let say I have a clumn of numbers, may I know how to convert it into text format ? i.e. A B 1 2145 '2145 2 3621 '3621 3 6147 '6147 What formula must I input at B1 and copy down to get the answer ? Thanks Low -- A36B58K641 -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to convert number to text ?
Hello Dave,
Thanks for the formula. Low -- A36B58K641 "Dave Peterson" wrote: And if you always wanted 6 digits in your text string: =text(a1,"000000") Mr. Low wrote: Dear Sir, The number in text format is normally denoted by a ' before it. Eg. '62417, '47125 etc. Let say I have a clumn of numbers, may I know how to convert it into text format ? i.e. A B 1 2145 '2145 2 3621 '3621 3 6147 '6147 What formula must I input at B1 and copy down to get the answer ? Thanks Low -- A36B58K641 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to convert number to text ?
Hello Roger,
Thanks for the tip. Low A36B58K641 "Roger Govier" wrote: Hi The easiest way would be Select column ADataText to ColumnsNextNextColumn Data formatTextFinish or by formula it would be ="'"&A1 Copy down as far as required. Copy column BPaste SpecialValues -- Regards Roger Govier "Mr. Low" wrote in message ... Dear Sir, The number in text format is normally denoted by a ' before it. Eg. '62417, '47125 etc. Let say I have a clumn of numbers, may I know how to convert it into text format ? i.e. A B 1 2145 '2145 2 3621 '3621 3 6147 '6147 What formula must I input at B1 and copy down to get the answer ? Thanks Low -- A36B58K641 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to convert number to text ?
Hello Pete,
Thanks for the formula and the tip. Low -- A36B58K641 "Pete_UK" wrote: Put this in B1 to turn the number to text: =""&A1 and copy down. You can fix the values by highlighting column B, then <copy, Edit | Paste Special | Values (check) | OK | <Esc Hope this helps. Pete On Feb 29, 1:11 pm, Mr. Low wrote: Dear Sir, The number in text format is normally denoted by a ' before it. Eg. '62417, '47125 etc. Let say I have a clumn of numbers, may I know how to convert it into text format ? i.e. A B 1 2145 '2145 2 3621 '3621 3 6147 '6147 What formula must I input at B1 and copy down to get the answer ? Thanks Low -- A36B58K641 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to convert number to text ?
You're welcome - nice to see you posting again.
Pete "Mr. Low" wrote in message ... Hello Pete, Thanks for the formula and the tip. Low -- A36B58K641 "Pete_UK" wrote: Put this in B1 to turn the number to text: =""&A1 and copy down. You can fix the values by highlighting column B, then <copy, Edit | Paste Special | Values (check) | OK | <Esc Hope this helps. Pete On Feb 29, 1:11 pm, Mr. Low wrote: Dear Sir, The number in text format is normally denoted by a ' before it. Eg. '62417, '47125 etc. Let say I have a clumn of numbers, may I know how to convert it into text format ? i.e. A B 1 2145 '2145 2 3621 '3621 3 6147 '6147 What formula must I input at B1 and copy down to get the answer ? Thanks Low -- A36B58K641 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert text to number in excel | Excel Worksheet Functions | |||
| number convert to text in excel | Excel Discussion (Misc queries) | |||
| can we convert number to text in excel as if 1= One | Excel Discussion (Misc queries) | |||
| How do I convert a number in Excel to text? | Excel Worksheet Functions | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Linear Mode
