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