Split number with decimal places into 2 columns

[Guest]

I need a formular (if it can be done) to extract a number with decimal places
onto 2 columns.

Example:
Column A has the number and I want the whole number in B and the decimal in C
A B C
123.456 123 .456

 

[Bernard Liengme]

In B1; =INT(A1)
and in C1: =A1-B1 or =MOD(A1,1)
best wishes

 

[JE McGimpsey]

One way:

B1: =INT(A1)
C1: =MOD(A1,1)

 

[Guest]

Thank you both for your help.