Hey everyone,
In one of my process I receive an excel file which includes date values in one column. The problem I face is my excel is English and theirs is not so when they write 10.3.2021 as a cell value and send the excel to the robot via mail its seen as 3/10/2021. I know its not related specifically to RPA but I believe alot of you may have faced the same problem. What I want to do is not format the date value as in MM/DD/YYYY to dd.mm.yyyy because the user may have sent me the format wrong from the start so it wont be to safe to make robot alter the cell values.
So my question basically: Is there a way to prevent Excel to format the cell values? I want to see the excel the way its been sent, I dont want excel to make any changes. If its been sent as 10.3.2021 or whatever I want it to stay that way.
Thank you very much.