Hi all, I have a current workflow that assigns ‘Status’ from one workbook to another, the status contains the date format say 1-Jan-2022. However, in the new workbook it would appear in a different form 1/1/22 00:00:00. Is there a way to standardise the format or at least remove the time? [unnamed] …

Excel Date Formatting, applying wildcard to sheets

balupad14 (Balamurugan (BalaReva)) December 30, 2021, 9:51am 2

Yes. You can use the below activity that you can change the format.

video :

Regards
Balamurugan.S

2 Likes

Topic		Replies	Views
Changing the Date Format in a excel column Activities excel , activities , question	23	5989	September 16, 2021
How to change date format in excel file? Studio uiautomation	6	2431	December 9, 2022
I want to change a cell's format from generic to date Studio excel , activities , question	2	1682	June 21, 2020
Date format is changed when writing the data in excel Help excel , studio , question	3	2428	July 3, 2020
Change format Excel Studio	5	1280	August 10, 2020