Warning Number stored as text

Aspose.Cells Product Family
1

Hi,
I am getting warning as number stored as text, further scenarios i have explained in attached excel.
Any way i can handle that using aspose.cells dynamically because i will have multiple excels to fill the data i don’t want to add condition for each excel and column separately

Number As Text.zip (13.1 KB)

2

@Amrinder_Singh
Aspose.Cells provides the Cells.ConvertStringToNumericValue() method which can be used to convert all string or text numeric data into numbers. Please refer to the following document.

3

@Amrinder_Singh
You also can iterate all cells as How and Where to Use Enumerators|Documentation
then call Cell. PutValue(string ,true) to convert string to numeric value if the cell contains string value.