convert a number into two seperate numbers in two different cells.

I'm trying to figure out how to program this.

I have a cell with a number in it. Say 1.3 or 2.25 or 18, etc.

What I need to do is convert with a macro this cell into two cells. One cell containing everything before the decimal (ie 1, 2, 18) and the other cell to contain the rest (ie .3, .25, 0)

Is there a function that would help me do this? Thanks for the help!

You can simply use a worksheet function.

If your values are in column A then in another column put

=INT(A1)

and

=A1-INT(A1)

this can also be done with code if desired but if a worksheet function will provide the functionality you are looking for.

HTH