Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Converting Number into Words Post Reply Post New Topic
Author Message
VaniShree
Newbie
Newbie
Avatar

Joined: 07 Feb 2013
Online Status: Offline
Posts: 9
Quote VaniShree Replybullet Topic: Converting Number into Words
    Posted: 17 Feb 2013 at 11:26pm
Hello All,

I am trying to convert my value into words when am using TOWORDS(NUMBERS) my decimal values is not getting converted to words instead it is giving  output like this
To Words(123.4);

"one hundred twenty three  and 4 / 100"
but i want to display as 
one hundred twenty three  and four paisa

is there any i can do this ..
Dead
Vanishree
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet Posted: 18 Feb 2013 at 6:37am

Instead of sending the whole number, I would do something like this:

 
NumberVar paisa = NUMBERS mod 100;
 
ToWords(Truncate(NUMBERS)) + " and " + ToWords(paisa) + " paisa"
 
This splits off the decimal portion of the number and converts it to words separately.
 
-Dell
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.