Excel - Convert numbers to words

December 2016


Issue


I'm looking for a simple formula to convert numbers to words, in Excel 2007.

Solution


Try this:
=CONCATENATE(TEXT(UPPER(Spell Number(B6)),0),"ONLY")


Thanks to Max for this tip.

Related :

This document entitled « Excel - Convert numbers to words » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.