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))

Staff Training Programme

                                                               Download Link