Change of text to date format

Just a quick question. How to convert the “43587” into the date format “02.05.2018” in excel?
image

Thank you.

Hi @junnieset
in excel the cell with value 43587 will be in NUMBER format
change it to SHORT DATE format it will get converted to its date equivalent

Cheers @junnieset

1 Like

Hi @junnieset ,

This forum is to solve the Queries related to UiPath, and not related to Excel.
May be Googling it Will resolve your Queries faster and efficiently on topic other than UiPath.

Thanks,

@Vijay_Tulsalkar sorry I didn’t add that I got this after converting the data using uipath. So how should I do a conversion again?

@Palaniyappan sorry I didn’t add that I got this after converting the date from “2 May 2019” using uipath. Some becomes numbers, some remain in date format. After that the date will be entered in the system. So how should I do a conversion again?

@junnieset

Refer this below thread and see if this helps

or if you have the excel template saved in your system and just appending the values then try changing the Column format to datetime and save the excel template and then try appending

Give a try with the below method

DateTime.FromOADate(Value)

Hi @junnieset

Use cdate(row(“column name”).tostring)

Thanks
Ashwin.S