Thread: Adding periods (full stops) to the middle of numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Derek M[_2_] Derek M[_2_] is offline
external usenet poster
  
Posts: 18
Default Adding periods (full stops) to the middle of numbers
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

Reply With QuoteReply With Quote