ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Rendering Numbers into Written Words (https://www.excelbanter.com/excel-discussion-misc-queries/167981-rendering-numbers-into-written-words.html)

John

Rendering Numbers into Written Words
 
Is there a function or formatting code that will take numbers and convert
them into written words ie: "42" becomes "forty-two"
--
John

Pete_UK

Rendering Numbers into Written Words
 
Bob Phillips shows different ways to do this he

http://www.xldynamic.com/source/xld.xlFAQ0004.html

Hope this helps.

Pete

On Nov 30, 3:44 pm, John wrote:
Is there a function or formatting code that will take numbers and convert
them into written words ie: "42" becomes "forty-two"
--
John




All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com