Format about Amoutn/Accounting/Currency

[fjaweihyafie]

Hi,
Now I use stimulsoft to show Amount with the Text Format property , but it did not supply the format I needed .
eg:
$(2.00) //when the amount is negative
$100.00 // when the amount is positive
$- // whe the amount is zero

the format is same as in Microsoft Excel the cell format set to "Accounting"
Does anyone has the solution ? Thanks

[HighAley]

Hello.

There is no such text format type. But you could do all of it with expressions.

Thank you.

[fjaweihyafie]

Hello.

There is no such text format type. But you could do all of it with expressions.

Thank you.

Yeah , I could do all of it with expression . But when the value is zeor and should have showed as " - " , when I exported as excel ,in the cell it is " - " not zero , I will do some calculation depend on it , May the way of doing it with expression is not a correct way .
Any way else ?

[HighAley]

Hello.

You could use Excel Value property of the text component to set zero value.

Thank you.