• Status: Solved
• Priority: Medium
• Security: Public
• Views: 1014

# how to change thousand seprator format in numeric value

HI,
i am using crystal reports in vb 2006.

i am facing problem from long time to display numeric value with thousand seprator.

in crystal report numeric value shown as   116,791.00

but i want to display as indian format like  1,16,791.00

without changing client side system setting.

Regards
Navdeep
0
navdeepsunny
• 3
• 2
1 Solution

Commented:
Try this

Add a formula where you want the number displayed

Name - DispNumber
Formula
ToText({YourNumberField},"#,##,###.##")

mlmcc
0

Author Commented:
thanks lot

one more problem regarding this

in crystal report numeric value shown as   116,791.00

but  with help of formula ToText({YourNumberField},"#,##,###.##")

value shown as   1,16,791.00

but when i display in word it display "one hundred sixteen thosand seven hundred ninty one"

but i want to display " one lakh sixteen thousand hundred ninty one"

Regards
Navdeep
0

Commented:
To do that you will probably have to write your own translation function.

What formula or function are you using to convert the number to words?

mlmcc
0

Author Commented:
using towords() formaula from crystal reports to display amount in words.

Regards
Navdeep
0

Commented:
I don't know if towords can handle Indian currency.

Here is the beginning of a formula

Name - ToWordsIndian
Formula
WhilePrintingRecords;
StringVar strAmount := "";
NumberVar ValLakh := 0;
NumberVar ValRest := 0;
NumberVar intComma := 0;

strAmount := ToText({YourNumberFIeld}, "#,#####");
intComma := instr(StrAmount,",");
ValLakh := val(left(StrAmount,intComma - 1));
ValRest := val(mid(StrAmount,intComma + 1));
towords (ValLakh,0) & " lakh " & Towords(ValRest,0)

mlmcc
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.