Adding periods (full stops) to the middle of numbers
Unbeilevable!!!! thank you so much, i really appreciate it
Derek
"Jacob Skaria" wrote:
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
|