How to Remove Scientific Notation in Excel [2026]

Excel and Google Sheets convert long numbers like barcodes, SKUs, and tracking numbers into scientific notation (e.g. 1.23457E+12 instead of 1234567890123). This makes product data unusable for CSV imports, bulk uploads, and marketplace listings. Here are three proven methods to remove scientific notation and keep your numbers intact.

Why Does Scientific Notation Happen?

Excel and Google Sheets automatically display numbers longer than 11 digits in scientific notation (e.g. 2.5E+12). While this saves space for scientific data, it corrupts identifiers like UPC barcodes, EAN codes, product SKUs, and order tracking numbers that must remain exact. This is especially problematic when exporting to CSV or XLS for marketplace bulk uploads.

3 Methods to Remove Scientific Notation

Method 1: Format Cells as Text (Recommended)

This is the most reliable way to prevent Excel or Google Sheets from converting large numbers to scientific notation.

Steps in Excel:

1. Select the column containing your numbers (e.g, Variant SKU).
2. Right-click and choose Format Cells.
3. In the Number tab, select Text and click OK.
4. Enter your numbers again or double-click each cell to reapply the text format.

Steps in Google Sheets:

1. Select the column with your numbers.
2. Go to Format > Number > Plain Text.
3. Re-enter the numbers or click on each cell to update the format.

Note: Formatting cells as text prevents the data from being automatically converted to scientific notation.

Method 2: Apostrophe Prefix (') Before Numbers

Another quick way is to prefix your numbers with an apostrophe (').

Example:

• Instead of typing 1234567890123, type '1234567890123.

This method tells Excel or Google Sheets to treat the entry as text. The apostrophe will not appear in your data after exporting to CSV or XLS.

Method 3: TEXT Formula

If your data is already formatted in scientific notation, use the TEXT formula to convert it back to a regular number.

In Excel:

1. Use the formula =TEXT(A1, "0") where A1 is the cell with the scientific notation.
2. Drag the formula down to apply it to other cells in the column.

In Google Sheets:

1. Use the same formula =TEXT(A1, "0").
2. Apply it across the desired range.

The TEXT function converts the number to text format, ensuring it is not displayed in scientific notation.

Exporting as CSV or XLS Without Scientific Notation

Once you have applied one of the methods above, follow these steps to export your data:

1. In Excel: Go to File > Save As and choose the format (CSV or XLS).

• Make sure to select the option UTF-8 CSV if available to maintain proper encoding.

2. In Google Sheets: Go to File > Download > Comma-separated values (.csv, current sheet) or Microsoft Excel (.xlsx).

Tips to Avoid Scientific Notation When Importing CSV/XLS

• Open CSV files correctly : When opening a CSV file, avoid double-clicking it directly. Instead, import it into Excel or Google Sheets and specify the column format as Text during the import process.
• Use leading zeros in identifiers : For product codes, or variant skus that may start with zeros, ensure the format is set to Text to avoid losing the leading zeros.

Removing scientific notation in Excel or Google Sheets is essential for any ecommerce seller working with product data. Barcodes, SKUs, and tracking numbers must remain exact — a single digit change from E+ conversion can break marketplace uploads and inventory imports. Use the text format method for new data, the apostrophe trick for quick edits, or the TEXT formula to fix existing spreadsheets.