topic Re: Date Time Format in Excel - Keep Its Original Format in Product Forum

Date Time Format in Excel - Keep Its Original Format

Lily.L — Wed, 03 Apr 2024 08:11:36 GMT

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!

Re: Date Time Format in Excel - Keep Its Original Format

Lily.L — Wed, 03 Apr 2024 08:19:36 GMT

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

Re: Date Time Format in Excel - Keep Its Original Format

MichealCharron — Wed, 03 Apr 2024 12:48:39 GMT

@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;@

Re: Date Time Format in Excel - Keep Its Original Format

Lily.L — Wed, 03 Apr 2024 18:43:56 GMT

Thank you.