separating single cell value numbers in different cells

[sit]

First of all I want to thank Don Guillett, he gave me an idea how t
make this.
i've changed his formula =MID(TEXT(A1,"0.00"),1,1) into this
=MID(TEXT(A1,"0000000000.00"),1,1) so all the numbers to be displaye
from right to left. It is just fine, if i enter 1523.25 in the cell A
i get this result 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 2 | 3 | 2 | 5 i
cells A3, A4....etc., but i need to remove all those unusable 0 | 0 |
| 0's it works with "conditional formating" ( if cell value is equal t
0 -> font color=white) but if the number is 1503.25 i get this | 1 |
|empty | 3 | 2 | 5 this cell should not stay empty.
Any bright ideas

 

[Frank Kabel]

Hi
not really sure what your exact issue is?. Using Don's first formula
should prevent the zeros at the beginning