Data Conversion Issue

Help
,
1

When i am trying to enter the data in application from the excel i am facing a formatting issue (Ex: I am entering percentage value when i see in excel it is 3.00% but when the bot enters the data in application it is entering like 0.03% can you please find some solution for this).

1 Like
2

@Shiva_Goud1 Welcome to the UiPath Community.
Use Preserve Format checked while using Read Range activity. it will solve your issue.

3

@Shiva_Goud1
when the Excel is readin and the column format is recognized as a percentage column the value will be in the format of PercentValueFactor * 100 (Example: 3% = 0,03*100)

so will have 2 options:
Option 1 as mentioned by @Arpit_Kesharwani: tick on preserver format
Option 2: ExcelValue * 100 and if needed add the % sign on the end

1 Like
4

hi try adding this ’ before your data, ex '0.03%

1 Like
5

kindly mark it as solution if it worked for you.

6

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