Retain date format in excel using linq

Help Forum
, ,
#1

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

#2

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

image
image1920×1241 151 KB

#3

Hi @kavya.s16,

You can use change cell type.

image

Regards,
MY