Less than 10
 

In column A I have a numbers, 57, 86, 92. In column B I want the digits
greater than 10 from column A, so column B would look like 50, 80, 90. In
column C I want everything less than 10 from column A, so column C would be
7, 6, 2.

Less than 10
 

In B1
=trunc(a1/10)*10
or
=A1-Mod(A1,10)

in C1
=A1-B1
or
=Mod(A1,10)


then select B1 & C1 and drag fill down the column.

--
Regards,
Tom Ogilvy

"Matthew Coady" wrote in message
...
In column A I have a numbers, 57, 86, 92. In column B I want the digits
greater than 10 from column A, so column B would look like 50, 80, 90. In
column C I want everything less than 10 from column A, so column C would
be
7, 6, 2.