How to change the cell format to currency?

[Tana20]

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

[prasath17 (Guru)]

@Tana20 - Please try this

str.Insert(0,“$”)

[Tana20]

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

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

[prasath17 (Guru)]

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

Yes in Assign activity …

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

[Tana20]

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…

[prasath17 (Guru)]

@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.

[Tana20]

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?

[prasath17 (Guru)]

@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,“$”)

[moenk (Thomas Meier)]

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

Invoke VBA