thanks, however i needed something a bit more advance. What luke m submitted
was exactly what i needed

"Gary''s Student" wrote:

=CHOOSE(A1+1,"zero","one","two","three","four","fi ve","six","seven","eight","nine",)

--
Gary''s Student - gsnu200903