Retain date format in excel using linq

Hi everyone

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

any suggestions
@Palaniyappan @ppr @Yoichi @Rahul_Unnikrishnan
Thanks in advance

Hello @kavya.s16

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

Hi @kavya.s16,

You can use change cell type.

image

Regards,
MY