When data is downloaded into Excel, numeric data has exponents.

RESOLUTION

To resolve this, make the column width in Excel larger. If this still does not get rid of the exponential notation, select the column and right-click to format the cells. Specify that the data is to be interpreted as a Number and set the decimal places. For the Date/Time Stamp that is downloaded, format the cells to be a number and set the number to 0 decimal points.

This article last updated: 1/1/2009 12:00:00 AM