Excel 2002: How to convert number to text ?

  • Thread starter Thread starter Mr. Low
  • Start date Start date
M

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
 
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
 
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
 
Back
Top