# How to convert Amount in Words using Crystal Report?

Posted by Laghaterohan under Regular Expressions on 11/16/2010 | Points: 10 | Views : 28266 | Status : [Member] | Replies : 2
Hello,

Can any one let me know how to convert Amount in INR into Words using Crystal Report??

I am using TOWORDS function for the same in crystal reports however it is not working properly.

If i use TOWORDS(2) It gives me output as 2 and xx/100 ...
so if i use TOWORDS(2,0) It gives me 2 ...which is correct however i can't use then values with decimal.

Secondly, if i have values in lakh it does not display amount properly.

Please can any one let me know how to get it working???

Thanks!!

Best Regards,
Rohan Laghate

#### Responses

Posted by: Lalji_mer on: 11/17/2010 [Member] Bronze | Points: 25
 0 Hi, Good Morning. create a formula and insert a formula like: `ToWords ({Employees.EmployeeID},0)` then place it in your report. This will display the number in words with no decimal places. If you want decimals change the ",0" Look here good article for convert Amount in Words using Crystal Report in vb.net http://www.dotnetspider.com/resources/5462-How-Convert-Rupee-Value-Words-using-VB-NET.aspx More about will help http://www.eggheadcafe.com/community/aspnet/14/10016462/how-to-change-number-into-words-in-crystal-reports.aspx Here converter will help you http://converter.telerik.com/Default.aspx LP MERLaghaterohan, if this helps please login to Mark As Answer. | Alert Moderator
Posted by: T.saravanan on: 11/18/2010 [Member] [MVP] Silver | Points: 25