Parse date into a single format

HI @Dhruvi_Arumugam

In this case you can try with Format cell activity to get the desired format.

You can try to change the format of the column

  1. Excel process scope activity
  2. Use excel file activity
  3. Format cell activity

image

Check out this XAML file

FormatCellStudioX.xaml (8.5 KB)

Or

Try with BalaReva it will applicable only in Window Legacy

Check out the thread

Regards
Gokul