Certain decimal values are interpreted as dates when using write csv activity

Help Studio
, ,
1

Whenever I write my datatable into a csv file with write csv activity some decimal values like 3.12 are being interpreted as a date like 3rd December. If I open the csv file with the notepad application this issue doesnt occur but as soon as I use the excel application this exact problem appears. Is there a way to fix this?

1 Like
2

Hey @Oezkurt_Bilal

This is most probably due to the Excel auto formatting !

What is the expectation here pls ?

Thanks
#nK

3

When the csv file is being used with excel I dont want there to be a mix up of decimal values and dates. I was asumming there was a way of fixing it through UIPath.