O'Reilly logo

Excel® 2013 In Depth by Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required