Excel offers many functions for dealing with basic math, dates and times, and text. This chapter describes the functions found under the Text icon, the Date & Time icon, and the Math portion of the Math & Trig icon on the Formulas tab. Trig functions are covered in Chapter 15, “Using Trig, Matrix, and Engineering Functions.”
A few of the new functions in Excel 2013 fall into this chapter:
• NUMBERVALUE—Converts text numbers to their number value, even when the text contains foreign punctuation. For example, your country might show numbers as $1,234.56. A text file from a foreign subsidiary might include that same number with punctuation of $1.234,56. The new
NUMBERVALUE provides ...