Change Format from date to general

Help
1

Hello,

I have selected a particular range in excel which is dynamic. After applying the formula to it is automatically getting converted to date format. I want to change it to general format without using hotkeys. i have already tried using hotkeys it works only when the excel workbook is visible. Someone please provide an alternate solution.

image
image595Ă—932 39.4 KB

Thank you.

1 Like
2

hi @Jagadesh2494

Use int var=cint(row(“DtNec” ).ToString)

Thanks
ashwin S

3

Hi,

Could you please share the workflow?

4

hi @Jagadesh2494

Main.xaml (7.3 KB)

Th@nks

@shwin S

5

Hi,

Am getting the below error. when i run that code

image
image868Ă—303 16 KB

6

May I know what is that formula
Cheers @Jagadesh2494

7

Hello @Jagadesh2494 you also try below VBScript
use Invoke VBScript activity
you can change the file name and column range according to your needs…

Make sure to change file extension to .vbs after downloading…
ChangeFormat.json (826 Bytes)

8

=today()-J2-1

Note : I applied this formula in cell K2 using write cell activity

9

Sorry i couldn’t open the file even after changing it to.vbs. Could you please share the work flow

10

Hi guys,

I got the solution. thanks for your input friends :slight_smile:

1 Like
11

Great
Cheers @Jagadesh2494

12

That’s great… :+1::+1:
if possible can you tell us your solution

13

I used this code in the invoke VBA method.

image

1 Like