# convert currency to word in crystal report

• ### Question

• User-1495932509 posted
Dear brothers, Please can anyone help me with function in crystal report that will help me convert currency to word. I will ge verry glad to see your reply on this question Thank you so much
Friday, March 2, 2012 2:16 AM

• User-926023460 posted

i m giving example ,

Ucase(left(towords({builtydetails.MrAmount}),len(towords({builtydetails.MrAmount}))-13) & " Only.")

• Marked as answer by Thursday, October 7, 2021 12:00 AM
Friday, March 2, 2012 2:18 AM
• User-926023460 posted

use this formula this is the indian currency converter plz chek it in urs..

"Rs. "+ ToWords ({@calculate_TotalAmtwithChrges},0) + " and " +ToWords ((Round({@calculate_TotalAmtwithChrges},2) - Int({@calculate_TotalAmtwithChrges})) * 100, 0) + " Paise only"

• Marked as answer by Thursday, October 7, 2021 12:00 AM
Friday, March 2, 2012 2:49 AM

### All replies

• User-926023460 posted

i m giving example ,

Ucase(left(towords({builtydetails.MrAmount}),len(towords({builtydetails.MrAmount}))-13) & " Only.")

• Marked as answer by Thursday, October 7, 2021 12:00 AM
Friday, March 2, 2012 2:18 AM
• User-1495932509 posted
Sir, I am new in crystal report how can i put it as function to be used in the crystal report Thank you sir
Friday, March 2, 2012 2:22 AM
• User-926023460 posted

Go to filed explorer and create new Formula filed ,

in that edit formula paste it ..

it sholud be work for you..

Friday, March 2, 2012 2:24 AM
• User-1495932509 posted
Yes sir, I works thank you somuch i am verry greatful But how can i convert the digit behind the decimal point 100.45 the 45 as cent can i convrt it too? Thank you sir
Friday, March 2, 2012 2:38 AM
• User-926023460 posted

use this formula this is the indian currency converter plz chek it in urs..

"Rs. "+ ToWords ({@calculate_TotalAmtwithChrges},0) + " and " +ToWords ((Round({@calculate_TotalAmtwithChrges},2) - Int({@calculate_TotalAmtwithChrges})) * 100, 0) + " Paise only"

• Marked as answer by Thursday, October 7, 2021 12:00 AM
Friday, March 2, 2012 2:49 AM
• User-926023460 posted

hi aliyuusman4u If U get the answers of ur question then Plz and Plz mark As Answers for this person who gave the answer for your questionss,,,