Need some macro help.

[odin1701]

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!

[mudraker]

Please read forum rules - see links below

Closing thread for invalid thread title