Write string to excel generates date

Help
1

Hi everyone,

I have a string 01-07-2019 when I use the write cell activity, in Excel the string is shown as 7/01/2019. If my string is 13-07-2019 and I use the write cell activity, in Excel the string is shown correctly as 13-07-2019. I always want my string written away in the format dd-mm-yyyy. How can i achieve this? Thanks in advance!

2

You can set the format of the column or cell in the excel and use write cell activity.

1 Like
3

But with the write cell activity, the format of the cell in excel is overwritten every time

4

Can you check the date setting in your machine or share the project file.

5

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