Error when transfer CSV to XLSX

[KristianHolm1]

​Hi Blueprism I have found an error when you transfer from CSV to XLSX file some text will be changed from

3-3044 to 01-03-3044

5-4032 to 01-05-4032

I have attached a test process where you can replicate the error.

greetings

------------------------------
Kristian Holm
RPA programmer
PenSam (Pension Company)
Copenhagen Denmark
------------------------------

[PatrickAucoin]

Hi Kristian,

It looks like Excel is incorrectly interpreting and automatically formatting your data as a date. Here is an article from Microsoft Support on how to address this issue:

"Stop automatically changing numbers to dates"
https://support.microsoft.com/en-us/office/stop-automatically-changing-numbers-to-dates-452bd2db-cc96-47d1-81e4-72cec11c4ed8
​
#Excel
​​

------------------------------
Patrick Aucoin
Senior Product Consultant
Blue Prism
------------------------------