11. Using Everyday Functions: Math, Date and Time, and Text Functions
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 ...
Get Excel® 2013 In Depth now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
