Microsoft Office Tutorials and References
In Depth Information
Looking It Up
Perhaps you need to display such a nice-looking number for the raw value it
really is. This is where NUMBERVALUE comes to the rescue.
Figure 14-15 shows a worksheet with two numbers in column A that are in
one way or another a bit non-numeric appearing. Besides 14.25 percent, there
is also “1 2 3 4” (this has spaces between each digit).
Column B shows how the numbers look using NUMBERVALUE. For example,
cell B3 contains this:
of a number.