Just a quick question. How to convert the “43587” into the date format “02.05.2018” in excel?
Thank you.
Just a quick question. How to convert the “43587” into the date format “02.05.2018” in excel?
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
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?
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)