Try something like this:
With a number in A1
B1: =--RIGHT(INT($A1/10^(10-COLUMN()+1)),1)
Copy that formula across through M1

Does that give you something to work with?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Hill" wrote:

> 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
>