Click to See Complete Forum and Search --> : convert a number into words


dev-1
May 2nd, 2006, 11:18 PM
can anyone help me how to convert a number into words using crystal report formula?
thanks

vidubhushan
May 11th, 2006, 05:07 AM
use Towords() function.

dev-1
May 15th, 2006, 11:04 PM
hi.. vidubhushan, thanx for your reply

Madhi
May 29th, 2006, 05:12 AM
Also you need to truncate the last xx/100 part if it exists

CandorZ
September 21st, 2010, 08:59 AM
http://social.msdn.microsoft.com/Forums/en-US/vscrystalreports/thread/5e2c8681-9d7d-4731-848e-d0e2cc8aa0b7 - lists the options you have to workout for conversion from Numeric to Words...
Its in Indian format (Lacs/Crores) but can be readily modified for use with Billions (Add 2 Zeros) and Millions (Add 1 Zero). Figure out yourself...

CandorZ
September 21st, 2010, 09:07 AM
http://social.msdn.microsoft.com/Forums/en-US/vscrystalreports/thread/5e2c8681-9d7d-4731-848e-d0e2cc8aa0b7 - Have a look... has some options/workarounds!!!