Convert Text to Currency

Convert Text to Currency

  

Hi,


At the picture i make some marks, and i want to ask how to delete 0000 number (red marker). and how to convert text to currency (black marker) which mean i want to display Rp 25427246.00 to Rp 25.427.246.00.


Thank you

Solution

Hi Bimo.

You can use the built-in function 

FormatDecimal(value,decimal_digits,decimal_separator,group_separator)

for both cases.

Eg.

FormatDecimal(3.140000,2,",",".") = "3,14"
FormatDecimal(25427246.00,2,",",".") = "25.427.246,00"

Remember the output of these functions is a TEXT, so it's mostly used for presentation/text formatting.

Solution

António Chinita wrote:

Hi Bimo.

You can use the built-in function 

FormatDecimal(value,decimal_digits,decimal_separator,group_separator)

for both cases.

Eg.

FormatDecimal(3.140000,2,",",".") = "3,14"
FormatDecimal(25427246.00,2,",",".") = "25.427.246,00"

Remember the output of these functions is a TEXT, so it's mostly used for presentation/text formatting.


Thank you António Chinita! :D