how can I split a number of cell units tens hundreds ...

[Mozenrath]

how can if i have the number 1158,21 in A1 to get in b1=g1 c1=h1 d1=i5 e1=j8 f1=k21 or 3246,87 in A1 to get in b1=g3 c1=h2 d1=i4 e1=j6 f1=k87
Thank you

[Mozenrath]

or if i have 1158,21 in a1 then b1=1 c1=1 d1=5 e1=21

[oeldere]

See the attached file

Dutch

Please Login or Register  to view this content.

For the english version, see the attached file.

[popipipo]

Take a look at this

[Mozenrath]

Great THANK YOU VERY MUCH

[oeldere]

@mozenrath

Please add to whom you're responding.

[MarvinP]

Hi Mozenrath,

How about using the Int and Mod functions to get your answer? See the attached with simple formulas.

[Mozenrath]

hi Oeklere
Both of the answers are great and i'm grateful to both of you this is why i didn't add to whom am i responding.
And i see you have a great knowledge of excel.
Thank you for your assistance very much.

[oeldere]

Thanks for the reply.

Glad I could help.

Maybe you can also respond on the solution of MarvinP in #7.