There have been many times when I've wanted the cardinal version instead of the numeral version of a number. You could use a lookup table where you've typed out all the possible names but it's a pain to fill the whole thing in and then the formula only works for the number's you've manually typed.

How can I take any numeric value in Excel and spell it out in English?