G Guest Feb 18, 2006 #2 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
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
P Peo Sjoblom Feb 18, 2006 #3 What if the number is 12,575.98? -- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon
G Guest Feb 18, 2006 #4 That is not what CQ asked. Your question is a whole different kettle of fish, for which I am sure you know the answer.
That is not what CQ asked. Your question is a whole different kettle of fish, for which I am sure you know the answer.
