In this lesson you will learn how to disable scientific notation (eg.1,23457E+17) in Excel spreadsheet.

This problem exists when you want to paste long number. Pasting it to the spreadsheet Excel change formatting to scientific notation (eg.1,23457E+17).

Scientific Notation

This problem is caused by Excel which has a 15 digit precision limit. It's annoying, because most of the time, I'd prefer it if Excel just treated the number as text (until I want it sorted). You can solve this problem.

Just right click on the cell and choose Format cell.

Format Cells

Change the format from General to Number with zero number of decimal places.

Format Cells Number Zero Decimal Places

Now this problem doesn't exist any more.

Display Scientific Notation


  • This solution works also for other typer of formatting. For example Custom with single 0 or Text.
  • The number format does not affect the actual cell value, which is displayed in the formula bar.
  • When Excel displays cell such ##### it means that cell is to narrow. Just make it wider.
Further reading: 
How to define custom number format?
Turning Off the Automatic Formatting of Dates
How to Exchange Formula to Value?
excel interview questions