Adding into cell
 

i wish to change a cell that contains "27809980" to "27.809.980" it is a text
cell

Adding into cell
 

You can use a formula in another cell:

=CONCATENATE(LEFT(A1,2),".",MID(A1,3,3),".",RIGHT( A2,3))

Andrea Jones
www.stratatraining.co.uk
www.wrekinpublishing.com

"fazz" wrote:

i wish to change a cell that contains "27809980" to "27.809.980" it is a text
cell

Adding into cell
 

=LEFT(A1,2)&"."&MID(A1,3,3)&"."&RIGHT(A1,3)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"fazz" wrote in message
...
i wish to change a cell that contains "27809980" to "27.809.980" it is a
text
cell