Change format Excel

Help Studio
1

Hello,

Current format cell in Excel = “Custom” - “h:mm” (example 7:15).
I would like to change this format into text. But if I do it manually, the output becomes : 0.302083333333333. It should remain 7:15.

My question : which activity should I use to change the format and keeping the text?
Already tried with Balareva activities, unfortunately not knowing how to manage.

Thanks in advance!
Sven

1 Like
2

Hi @pilisan

Welcome to UiPath Forum

Have a look to the below thread :-

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

3

Hi @pilisan

Welcome to UiPath Community !

check this video . you can get clear idea.

Regards
Balamurugan.S

1 Like
4

Hello @Pratik_Wavhal,

I’ve already seen this video and I’m afraid this won’t help me further, but thanks already for responding.

I would like to have an in-depth sight into the needed activities and corresponding parameters.
I tried different scenario’s but without result.

Important to know that the destination Excel file include macro’s/formulas.

Kind regards,
Sven

5

Hello,

Thank you guys for responding!
Meanwhile, after lots of trial and error, I found a solution.

Sven

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.