how do i separate cell value in four different cells?

S

sit

Thanks for the tip but i think i should explain some more. If th
amount is 250.50 (USD) it should be displayed in the last 5 cell
excluding the dot(assuming that amount is no more than five digits an
50 cents).
This shoud be a simple accounting operation to transfer a single cel
ammount in to assignet cells to the right.
If you have ideas... help pleas
 
D

Don Guillett

try these
=MID(TEXT(A1,"0.00"),1,1) =MID(TEXT(A1,"0.00"),2,1)
=MID(TEXT(A1,"0.00"),3,1)


5,1
6,1
 
Top