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


You specify a total of 12 digits (2+4+4+2) but your example is only 11. Was
that a mistake, or are you expecting to pad the end with zeros?