Hi CQ

My 2c worth, I'd set up a table containing the numbers 0 - 9, with their
numeric and text values, and then use a VLOOKUP to get the Two iso 2. Iow,
if you have 2 in A1, then in B1 enter =VLOOKUP(A1,List,2,FALSE)
hth

"CQ" wrote:

how to converts a number to text eg. "2" become "two"