Or even this way...

=TEXT(A1,"00\.0000\.0000\.00")

--
Rick (MVP - Excel)


"Jacob Skaria" wrote in message
...
If you mean as text then try the formula//

=LEFT(A2,2)&"."&MID(A2,3,4)&"."&MID(A2,7,4)&"."&MI D(A2,11,10)

If this post helps click Yes
---------------
Jacob Skaria


"Derek M" wrote:

Hi all

Heres my question and i wonder if someone can help

I need to change this number for example 52253580000

into this number for example 52.2535.8000.00

The full stops are after 2 digits then 4 digits then 4 digits then 2
digits

Is there a way of doinf this as i have 3000 odd lines to convert :)

Thanks in advance

Derek