Adding periods (full stops) to the middle of numbers
I just noticed the typo the Glenn pointed out. Where did you want the
missing zero placed... at the beginning (if so, then my formula works fine)
or at the end? I would note that Jacob's solution does not work for the
number you posted, so I am guessing that you actually have a 12digit number
and that the 11digit number you posted was a typo (I think this because you
said Jacob's formula worked for you). My formula will always work for
12digit numbers and it will work for a number composed of a smaller number
of digits as long as you want the missing digits to be zero filled at the
beginning.

Rick (MVP  Excel)
"Rick Rothstein" wrote in message
...
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
