Pages

10 Oct 2013

Number to Text Convert Formula for 0 to 99

For Example:
2   - Two
22 - Two Two
58 - Five Eight
79 - Seven Nine
96 - Nine Six

Formula:

=IF(LEN(A1)=1,VLOOKUP(A1,{0,"Zero";1,"One";2,"Two";3,"Three";4,"Four";5,"Five";6,"Six";7,"Seven";8,"Eight";9,"Nine"},2,FALSE),VLOOKUP(VALUE(LEFT(A1,1)),{0,"Zero";1,"One";2,"Two";3,"Three";4,"Four";5,"Five";6,"Six";7,"Seven";8,"Eight";9,"Nine"},2,FALSE)&VLOOKUP(VALUE(RIGHT(A1,1)),{0,"Zero";1,"One";2,"Two";3,"Three";4,"Four";5,"Five";6,"Six";7,"Seven";8,"Eight";9,"Nine"},2,FALSE))

No comments:

Post a Comment