Convert Text Numeric Data to Number

Sometimes, you want to convert numeric data entered as text to numbers. You can enter numbers as text in Microsoft Excel by putting an apostrophe before a number, for example ‘12345. Excel then treats the number as a string. Aspose.Cells allows you to convert strings to numbers.

Aspose.Cells provides the Cells.ConvertStringToNumericValue() method which can be used to convert all string or text numeric data into numbers.

The following screenshot shows string numbers in cells A1:A17. String numbers are aligned to the left.

Input file: numbers entered as text strings

These string numbers have been converted to numbers using Cells.ConvertStringToNumericValue() in the following screenshot. As you can see, they are now right-aligned.

Output file: the strings have been converted to numbers

C# code to convert string numeric data to actual numbers

The following sample code illustrates how to convert all string numeric data to actual numbers in all worksheets.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

// Instantiate workbook object with an Excel file
Workbook workbook = new Workbook(dataDir + "SampleBook.xlsx");

for (int i = 0; i < workbook.Worksheets.Count; i++)
{
    workbook.Worksheets[i].Cells.ConvertStringToNumericValue();
}

workbook.Save(dataDir + "output_out.xlsx");