Split up number

Originally Posted by rizmomin

Hello Guys:

It seems to be not working..please help

A2=12.14, please help split this up B2=12 and C2=14

Thanks again

Riz

Fro the first part

=INT(A2) will give you 12

For the second part:

=MOD(A2,1)*100 will give you 14

if you need 0.14

=MOD(A2,1)