Skip to Content (Press Enter)
2020-11-13 06-20-57
Kane Loony
74Views
2Comments
Solved
Get text from decimals with decimal value .00 or .50
Question
Traditional Web

Hi All,


Ho can I get text value from decimal value with decimal .00 or .50

I using DecimalToText function with given parameter decimal is 10000.00 and 10000.50 but in screen showing like this

I want showing text like this

Thanks,

Kane

0
0
28 Sep 2022
Copy Link
2021-10-09 07-57-44
Stefan Weber
 
MVP
Solution

Hi,

use the function FormatDecimal in your expression. E.g.. FormatDecimal(10000.5,2,".",",") will give you 10,000.50.

First parameter is the value, then comes the number of digits, the decimal separator and the group separator.

Best

Stefan

0
0
28 Sep 2022
Copy Link
2020-11-13 06-20-57
Kane Loony

Hii,

that's my wish, Thanks

0
0
28 Sep 2022
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.