Generate Text String
Is there a method for generating a text string for a number (e.g., 1234
generates "One thousand two hundred thirty four")? Thanks |
There is no built-in way to do this. You need VBA or an addin, like Morefunc
from http://xcell05.free.fr/ HTH. Best wishes Harald "Joe S." skrev i melding ... Is there a method for generating a text string for a number (e.g., 1234 generates "One thousand two hundred thirty four")? Thanks |
Joe
See Bob Phillips' site. http://www.xldynamic.com/source/xld.xlFAQ0004.html Gord Dibben Excel MVP On Wed, 2 Mar 2005 11:41:02 -0800, Joe S. wrote: Is there a method for generating a text string for a number (e.g., 1234 generates "One thousand two hundred thirty four")? Thanks |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com