function to convert number to words [ 21 = "twenty one " ]

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

venu - 19 May 2006 13:43 GMT

any standard function to perform this operation ?

Reply to this Message

Bob Phillips - 19 May 2006 13:53 GMT

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

Signature

HTH

Bob Phillips

(remove xxx from email address if mailing direct)

> any standard function to perform this operation ?

Reply to this Message

Duke Carey - 19 May 2006 14:01 GMT

No. See this link for info on how to implement a VBA-based solution

http://groups.google.com/group/microsoft.public.excel.programming/browse_thread/
thread/fde17ec3c5502d0b/f3d2fb0cd19cdc0c?lnk=st&q=%22numbers+to+text%22+group%3A
*excel*&rnum=10&hl=en#f3d2fb0cd19cdc0c

> any standard function to perform this operation ?

Reply to this Message