Hai, I have one column NTD/NTE data is 1/12/2024 (MDY) format i want 12/1/2024 (DMY). change whole column without foreach because i have so many rows . foreach affect performance. Regards

@MD_Farhan1 Try mention like below Excel.Sheet("Sheet2").Range("A:A") [image] [image] Change Date Format(MDY)to(DMY) Studio Hi @MD_Farhan1 How about the following? [image] [image] Input: [image] Output: [image] Cheers!!

Change Date Format(MDY)to(DMY)

Help Studio

lrtetala (Lakshman Reddy) January 16, 2024, 9:44am 5

Hi @MD_Farhan1

How about the following?

Input:

Output:

Cheers!!

Topic		Replies	Views
Change data column date format Academy Feedback datatable , activities , question , lp_developer_fnd	7	2376	January 25, 2021
Change date format at one once for the whole column in Datatable Help datatable , excel , uiautomation , studio	1	1841	October 9, 2020
How to convert column values from ddmmyyyy to ddmmmyyyy without loop for single column Activities excel , uiautomation , activities , linq , linq-query , expression	3	1225	March 31, 2022
Change datatable column type number to date Activities excel , activities , question	7	55	February 6, 2025
How can i convert any date format to "dd/mm/yyyy" Activities uiautomation	4	14870	October 15, 2021

Change Date Format(MDY)to(DMY)

Related topics