Hi Everyone,
I have some columns with data “#####”. I need to change this to proper format “String” before unloading the data to the queue. How can I achieve that?
Example: “#######” to “10.50”
I tried AutoFit and that didn’t help.
Hi,
What activity do you use to read the data?
In general, UiPath can read the value if PreserveFormat is off.
If possible, can you share your xlsx file?
Regards,
Hi, are you using formulas to get that data? or can you share more about the workflow, like screenshots so we can look at it
When a column isn’t wide enough to show all of the cell contents it shows #####. This doesn’t change actual value in the cell or column. It’s just formatting.
If it’s a dashboard or user facing report you are working on then only change the width of the column and it will be resolved else it’s fine to keep as it is.
Thanks,
Ashok 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.