while converting data from text to excel, in one column the data is not in the expected format
Eg: (Required: 0456474937512 instead of 4.56475+11)
is there any way to set excel column format using uipath?
I’ve tried giving the proper data type in build data table as well, still the same issue.
Thanks for the reply @baisilgee
For display purpose your solution is best, but I am using the values for next process as well, and in that case using any extra symbols like 'Value or =“Value” is misleading the data for further process.
Is there any other alternative to achieve both requirements (Display & Accurate data), any activity or code if you can suggest.
Splitting the extra symbols for further processing or maintaining Template excel with proper formatting could be another solution but I am just curious if there is any way to easily handle formatting issues or format warnings in excel.