Report Offensive Message

Assuming we are looking for (-10) + (-0.2) as the split, using the example given, an alternative method is to use the absolute value of the number to get the integer part: and multiply by the sign to get the positive or negative.

Thus, if the number is in cell A1 we can put the integer part in B1:
B1 = INT(ABS(A1))*SIGN(A1)
and the decimal part in C1
C1 = A1 - B1