I have an input excel which has many date columns , initially the date format is in dd/MM/yyyy format in excel while i use read range or write the date format automatically changes to MM/dd/yyyy which is system format , but i need them in dd/MM/yyyy format only
@Palaniyappan @ppr @Yoichi @Rahul_Unnikrishnan
Thanks in advance
Can you do the same thing in excel itself. You can set the format for each column as per the requirement by setting the format.(format cell in excel)
Else you can use Format cell activity. https://docs.uipath.com/activities/docs/format-range-x
You can use change cell type.