Excel 2002: How to convert number to text ?

[Mr. Low]

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

 

[Roger Govier]

Hi

The easiest way would be
Select column A>Data>Text to Columns>Next>Next>Column Data
format>Text>Finish

or by formula it would be
="'"&A1
Copy down as far as required.
Copy column B>Paste Special>Values

 

[Pete_UK]

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

 

[Dave Peterson]

And if you always wanted 6 digits in your text string:

=text(a1,"000000")

 

[Mr. Low]

Hello Dave,

Thanks for the formula.

Low

 

[Mr. Low]

Hello Roger,

Thanks for the tip.

Low


A36B58K641

 

[Mr. Low]

Hello Pete,

Thanks for the formula and the tip.

Low

 

[Pete_UK]

You're welcome - nice to see you posting again.

Pete