cancel
Showing results for 
Search instead for 
Did you mean: 

Date Time Format in Excel - Keep Its Original Format

Lily.L
Level 5

Hi All,

I have an Excel file as below. 

LilyL_0-1712130881190.png

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

LilyL_1-1712131052304.png

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.

LilyL_2-1712131367904.png

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]

LilyL_3-1712131449415.png 

LilyL_6-1712131876429.png

 

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!

LilyL_4-1712131708765.png

 

 

 

 

3 REPLIES 3

Lily.L
Level 5

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

MichealCharron
Level 8

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

Format Cells.png

 

Micheal Charron
RBC
Toronto, Ontario
Canada

Thank you.