I have already tried with Balareva activity Change Cell Type activity… it did not work bro
Insert a new column b/w T and U. And inser formula like below.
Post applying a formula in cells change the format of the cells as “Custome” with format as “dd/mm/yyyy”. This will convert into required format.
will try and get back to you bro . Thank you @Utpal_Shah
it worked bro but how to apply for multiple columns…in my excel, I need to change from column N to column T May I know how to get this done for multiple columns?
Please find my excel for your reference.data-export-20201016000001-swaps.xlsx (1.1 MB)
implemented on the ’ trick to force Excel to keep values as text and blocks auto formats
one column required reformating due long numbers
How ever using a macro / invoke VBA would be another option as it is working directly to the source it is maybe the more strict approach.
will check and update you soon @ppr Thank you
I have used the below activities to get the solution.
- DateTime ParseTo Datatable
- CopyTo Clipboard
- Paste Clipboard
- Change Cell Type
Here is the solution.
ChangeFormat.zip (1.1 MB)
End of the DateTime, it has Z(Zone). So it added for 1 hour. Because I am in the daylight zone.
Check this one.
Thank you so much @balupad14 I will go through it and get back to you on this.
Hi @balupad14 May I know do I need to do any changes in the code in order to get the DateTime Zone or can I proceed to implement as you have shared?