9.3 Checking Recording and Measurement Data with Excel
144
Measured values are displayed exponentially so that the instrument can accommo-
date values of varying lengths. To make it easier to view data in Excel, exponential
data can be converted into numerical data.
Converting Measured Value Exponential Data
1
Select the column labels you wish to convert into numerical data and right-
click with the mouse.
2
Select [Format Cells].
3
On the [Format Cells] dialog box, click the [Number] tab.
4
Select [Number].
5
Change the number of decimal places as necessary and click [OK].
Click
Example
The figure shows column D, E, and F are
selected (Microsoft Office Excel 2003)