How to separate - let say - 278.950 (in cell A1) become :

(B1) 2 pcs of 100.000
(C1) 1 pc of 50.000
(D1) 1 pc of 20.000
(E1) 1 pc of 5.000
(F1) 3 pcs of 1.000
(G1) 1 pc of 500
(H1) 4 pcs of 100
(I1) 1 pc of 50

I have hundreds more in colomn A (down)
Finally when I sum colomn down I have .... pcs of 100.000, 50.000,
20.000,,,, etc

I hope someone will understand to what I mean

thx