How to change the cell format to currency?

Hi All,

Do you know what is the easy way to change cell format in Excel?

Example:
Input value : 641.25
Expected number format: $641.25

Note: I can only use official activities…

Thanks

1 Like

@Tana20 - Please try this

str.Insert(0,"$")

image

Thanks @prasath17…but the image you added is not available, :frowning:

Where do you recommend using it? In an “Assign” activity maybe?

@Tana20 -Image is showing now…please check…(I restarted the machine and its working now :frowning: )

Yes in Assign activity …

Str = “641.25”
StrPrefix = str.Insert(0,"$")
Message box = StrPrefix
Output: $641.25

1 Like

How can I apply that to a column in Excel? for instance I would like to apply that format to column “A” except the header…

@Tana20 - Here is the sample xaml Main.xaml (8.4 KB)

Output

Suggestion : If you would have asked this at the first point, I would have provided this solution. So next time when you ask, please provide your exact query.

Please mark this as solution, if it solves your query.

I totally agree with you, I’m still working on my first project and I’m just getting used to using the forum; thank you for this and other recommendations you have given me.

Now, regarding the .xaml … I can’t open it in UiPath Studio, it had happened to me before. Maybe the UiPath versions are incompatible?

image
image

@Tana20 - save the xaml inside the new folder. After that try to double click from there. Here is the image…

Assign–> row.Item(“Y”) = row.Item(“Y”).ToString.Insert(0,"$")

1 Like

Also consider injecting VBA Code to do the Excel Magic, its easy and stable:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.