How To Convert Numbers to Words in Excel

July 2016


[Excel] A formula to convert number to words


Issue

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

Solution

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

See also :

This document entitled « How To Convert Numbers to Words in Excel » 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.