How Convert Excel Column From Text To Number Format

Help Studio
,
1

Hi !

I am trying to write in excel file " Integer Value " but unfortunately Its showing error “Number stored as Text format”, as shown in below image.

Capture2

Could anyone help me please? Thanks

1 Like
2

Hi @Teaf

You can install the package → BalaReva.Excel.Activities

Change Cell Type Activity

image
image1441×476 35.6 KB

Regards
Gokul

1 Like
3

Hi @Teaf ,

you can create a vb and convert the column in any format. you can call the vb by invoke vba activity.

thanks

4

I tried , changed the column format to number but when i click on the cell showing the same warning that “Number stored as Text format”.

5

i tried the below but unfortunately not work .

6

Can you show your code? Also please let me know what cell type you want and what is the column Address

7

I solved it.Thanks !

8

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