How Convert Excel Column From Text To Number Format

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.


Could anyone help me please? Thanks

1 Like

Hi @Teaf

You can install the package → BalaReva.Excel.Activities

Change Cell Type Activity


1 Like

Hi @Teaf ,

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


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”.

i tried the below but unfortunately not work .

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

I solved it.Thanks !

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