Computer Training

Microsoft Excel 2007 - Importing Data into Excel - Numbers and the letter "E"

Click on the video icon for a demonstration

When importing a data file (CSV- comma separated values) that contains numbers, the letter "E," and then more numbers in one column, Excel assumes the data contains numeric values in scientific notation.

Once imported, Excel formats the data as scientific notation. You can avoid this by following the steps below.

How to:

1. Open Excel, click the Data tab, and then the “From Text” command in the Get External Data group.
2. Locate and open the data file.
3. Choose Delimited as the File type that best describes your datas. Click Next.
4. Place a check in the box Comma and then click Next.
5. Cilck in the column that contains the numbers and the letter "E."
6. On the same screen, change the data format to Text.
7. Click Finish and then OK.