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