One way:

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

In article ,
meridklt wrote:

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