Ask a question »

Excel -A formula to convert number to words

June 2013


[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

Knowledge communities.

Published by aakai1056 - Latest update by Jeff
This document entitled « Excel -A formula to convert number to words » from Kioskea (en.kioskea.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.
Excel - A Macro for counting duplicates in row Excel - Edit text in specific cells
Receive our newsletter

health.kioskea.net

Excel - A Macro for counting duplicates in row
Excel - Edit text in specific cells