[help] Convert number to currency

12 years 3 months ago #13650 by ducla

[help] Convert number to currency was created by ducla

I have a problem.
I have a string number.
I want convert to the currency.
ex :
string : 1234567
currency : 1.234.567
Please help me.
Thanks

Please Log in or Create an account to join the conversation.

12 years 3 months ago #13651 by jpb

Replied by jpb on topic [help] Convert number to currency

Using the FMT function and setting the delimiters will work.

String = "1234567"
EXEC "SET-THOUS ."
EXEC "SET-DEC ,"
Ccy = FMT(String,"R,")
CRT Ccy

another way would be to use FMT and then replace , by .

Please Log in or Create an account to join the conversation.

12 years 3 months ago #13653 by ducla

Replied by ducla on topic [help] Convert number to currency

Thanks so much
It's done!

Please Log in or Create an account to join the conversation.

Time to create page: 0.026 seconds