Use the INT function. In cell B1 enter:

=INT(A1)

Copy down as needed.

HTH,
Elkar


"The Rook" wrote:

In column A I have a lift of numbers that are upto 10 decimal places. I
would like to populate column B with what is to the left of the decimal point
in column A in the same row.
Can this be done?