Need support on displaying value in comma delimited way like $xxx,xxx.xx in UiPath Vb Apps

Hi,

I need to display values in a comma-delimited way, like $xxx,xxx.xx in UiPath Vb Apps, and I would appreciate it if I could get an example that can be used in the expression editor of a label in UiPath Vb Apps.
Example: 192,855.44
Thanks in advance.

Hi @Kavindu_Dilshan ,
You can use VBA
The $ symbol in the numberformat is a placeholder for the currency of the local PC.

But if you surround that by and add currency symbol you want and the culture tag the format is “fixed”, example:

Sub Test()
With Range(“A1”)
.Value = 1
.NumberFormat = “[$$-en-US]#,##0.00”
End With
With Range(“A2”)
.Value = 2
.NumberFormat = “#,##0.00 [$€-de-DE]”
End With
End Sub

A1 is US-$, A2 is German €, try it.

https://answers.microsoft.com/en-us/msoffice/forum/all/setting-format-to-0-using-vba-showing-currency/2388466a-17a0-4eef-9ca2-579a9a22e88e
Regards,

Hi @Nguyen_Van_Luong1 ,

Thank you for your reply.
The above-mentioned methods are not available in UiPath Vb apps expression editor but available in UiPath Studio Could you please share more information, if possible?

Hi @Kavindu_Dilshan ,
image
You can use Invoke VBA activity inside Excel application scope
Type code VBA in Invoke VBA activity
Regards,

@Kavindu_Dilshan ,

Please use text box mask features and you can display input like as per your requirements.