How to create percentage datatype in uipath

[pradeep_ch (Pradeep Chinnala)]

how to create percentage datatype in uipath

[Niket_Ghai]

Percentage data type? Do you mean double data type?
If yes, then simply make the variable type to Double, if it’s not present you can browse for more types and search System.Double!
It’ll work

[loginerror (Maciej Kuźmicz)]

Hi @pradeep_ch

Do you mean to be able to save a value to Excel so that it shows % after opening the Excel file?
I do not think you can do it in UiPath unless you use a macro to set the format of the cell.

[pradeep_ch (Pradeep Chinnala)]

hi @loginerror
yeah i have to print the values in excel sheet
thanks for ur suggestion

[kewakerukeli (Bhaskar Ye)]

@loginerror,

I got it to work this way. Hope it counts:

PercentagesofExpenses.zip (45.6 KB)

[pradeep_ch (Pradeep Chinnala)]

Thanks

[kewakerukeli (Bhaskar Ye)]

@pradeep_ch,

Hi. Did you manage to use a macro as @loginerror suggested?

@loginerror

use a macro to set the format of the cell

If yes, can you show me how?

regards.

[loginerror (Maciej Kuźmicz)]

Hi @kewakerukeli

Please see this example below:
ExcelSimpleMacroCellFormat.zip (8.1 KB)

The macro is quite simple here:

Sub ChangeCellFormat()
    Range("A2").Style = "Percent"
End Sub

I simply recorded my actions via Excel and then browsed it afterwards by checking the Visual Basic code