Date Time Format in Excel - Keep Its Original Format

[Lily.L]

Hi All,

I have an Excel file as below. 

After I appended text / add column value in Column G, the 1st report collection looked like this

However, when the bot completed stages "write collection", "save workbook", and "close excel & instance", I opened the Excel file and saw that the column C format was different.

Here's my process, I have tried "Save Current Workbook As", Save Workbook", or "Save Workbook As". All have the same result for column C as "dd/MM/yyyy Time" [as picture above]

 

My question: Do we have any way we can keep the original format for column C and make the result look like this picture? Thank you!

[Lily.L]

I don't know coding, and not allowed to change code. I can only use BP objects. Thank you!

[MichealCharron]

@Lily.L 

It looks like your dates are resorting to the standard format of the machine the Excel is opened on. You can try the "Format Cell" action in Blue Prism's "MS Excel VBO" VBO to change the format of the column. Just add a new action stage to the page that uses the following value for the "Cell Format" parameter:

yyyy-MM-dd hh:mm:ss;@

[Lily.L]

Thank you.