View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
Posts: 8,520
Default Adding periods (full stops) to the middle of numbers

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