Split Decimal Values

[gurinderbti]

I have 188.432 values in kilogram in a single cell.. i want to split it into three different cells showing 1 quintal 88 kilo 432 grams

a.JPG

[zbor]

=INT(A1/100) quintal
=INT(A1-INT(A1/100)) kilo
=MOD(A1, 1) grams

[benishiryo]

welcome to the forum, gurinderbti. assuming 188.432 in E2, try this in A2:C2
=INT(E2/100)
=INT(MOD(E2,100))
=MOD(E2,1)*1000

[zbor]

Yes, *1000

[Ghozi Alkatiri]

=CONCATENATE(TRUNC(A1/10^5)&" quintal ",TRUNC(MOD(A1,10^5)/10^3)&" kilo ",MOD(A1,10^3)&" grams")