Value function to clean up No. stored as Text

This article describes the formula syntax and usage of the VALUE function in Microsoft Excel.
Converts a text string that represents a number to a number.
The VALUE function syntax has the following arguments:

Text Required. The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.