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

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

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

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

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

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

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

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