In B1; =INT(A1)
and in C1: =A1-B1 or =MOD(A1,1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email


"meridklt" wrote in message
...
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