Less than 10

[Guest]

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.

 

[Tom Ogilvy]

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.