Hi, I have this Date Column as shown below: [image] I want to change it to full sentence format as such: [image] So these are the months and how it should be written: [image] Can anyone help please? Thanks! UIPath_Excel_Scratch (1).xlsx (153.5 KB)

Hi @Yudhisteer_Chintaram1 ! Here is a suggestion: Date_conversion.xaml (9.7 KB) Beware, there is a strange date format at the end. I took care of it in the code through Try Catch but I wanted to let you know if it’s a forbidden/forgotten date format: [image]

Write full Date Format in Excel column

Help Activities

Yudhisteer_Chintaram1 (Yudhisteer Chintaram) May 6, 2021, 9:47am 13

Hi @Hiba_B ,

Just a quick question. What do we have to change to write the full Month?
That is, for now for “April” it is written “Apr”
But I want it to write “April” in full sentence?
Thanks!

Convert Column to DateTime Format after Merging

Topic		Replies	Views
Excel Regex Extract Date Activities datatable , excel , selector , uiautomation , data_scraping , question	7	1843	May 8, 2021
How to format the date in Excel Help datatable , excel , uiautomation , studio	2	1044	June 27, 2018
How to convert date in column to date format(dd/MM/yyyy) Studio studio , question , workflow_diff	18	806	October 5, 2023
Convert Date format while writing in Excel or Data Table Activities excel , activities , question	4	695	April 28, 2021
Date showing in excel and in the data table are different and needs conversion Activities datatable , uiautomation , activities , error	5	1473	March 24, 2021

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Write full Date Format in Excel column

Related Topics