Convert number text to number in excel and sum

[fairymemay (noona)]

I want sum column Amount , TAX and Net but number in file excel now form text.

I think it should convert number text to number right?

Please guide me about it.

Guide me about it.

[balupad14 (Balamurugan)]

HI @fairymemay,

To convert the number format , you can use this.

Excel Date column/General column conversion to dd-mm-yyyy format

Hi @Ashrita, Welcome to UiPath Community ! Here is an activity called “change cell type” . Using this activity that you can able to change cell type. Video explanation : [UiPath | How to change the cell or column format in Excel | Guide (datatype)] Regards Balamurugan.S

Regards
Balamurugan.S

[moenk (Thomas Meier)]

You can also read data to DataTable an loop over it and parse the strings to double.

Double.Parse Method (System)

[fairymemay (noona)]

@moenk How​ to​ use​ parse?