On 14 May, 18:17, JE McGimpsey wrote:
One way:

Integer part: =INT(A1)
Fractional Part: =MOD(A1,1)

In article .com,

" wrote:
Does anyone know of a way to split a decimal number????

both of these work really well. Thanks.

I decided to use the =Int(a1) and for the decimal part = right, 1, as
there is always 1 decimal place in all instances. I can see how the
others can be used to get around limitations of this tho.

Thanks again,

Great help.