perfect, both solutions solve the problem. thank you. also i didn't know
that @ right functions return text. --
aprilshowers


"april" wrote:

Column A Column B Column C
numbers =round(a1,0) =right(B1,1)

the numbers in Column C won't add. i keep getting -0-

thanks for your help
--
aprilshowers