separating single cell value numbers in different cells

  • Thread starter Thread starter sit
  • Start date Start date
S

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
 
Hi
not really sure what your exact issue is?. Using Don's first formula
should prevent the zeros at the beginning
 
Back
Top