Hi:
Here is a situation I have a column of numbers:
A1
10325.25
125.23
1.25


I need to split this data into columns. This has to be done in such a way
that all the cents will split into the same two column, all the thousands
fall in one column, all the hundreds fall in one column etc.

I tried using text to column but the numbers are left aligned so I cannot
get the decimal point to fall in the same column, and I do not want to use
leading zeros.

Can anyone help me achive this.

Thanks