convert number to word (text)
I WANT TO CONVERT NUMBER TO WORD
EXAMPAL 1005 CONVERT TO ONE THOUSNAD FIV |
Hi,
You could do this by downloading ASAP Utilities and use Numbers - Spell Numbers or amounts. http://www.asap-utilities.com/ Regards, A -- Please rate my response if you found it helpful. Thanks. "ROHIT" wrote: I WANT TO CONVERT NUMBER TO WORD EXAMPAL 1005 CONVERT TO ONE THOUSNAD FIV |
Rohit, have a look here,
http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "ROHIT" wrote in message ... I WANT TO CONVERT NUMBER TO WORD EXAMPAL 1005 CONVERT TO ONE THOUSNAD FIV |
This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip It's in the "Accountants" section on page: http://www.bygsoftware.com/examples/examples.htm It contains the "SPELLNUMBER" function, which can be used in your spreadsheets, two methods to convert numbers to words and two cheque writing routines. The code is open and commented. -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "ROHIT" wrote in message ... I WANT TO CONVERT NUMBER TO WORD EXAMPAL 1005 CONVERT TO ONE THOUSNAD FIV |
All times are GMT +1. The time now is 05:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com