Convert number text to number in excel and sum

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?

image

Please guide me about it.

Guide me about it.

HI @fairymemay,

To convert the number format , you can use this.

Regards
Balamurugan.S

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

@moenk How​ to​ use​ parse?