=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