If you ever enter a very large number into a cell, you’ll
notice that Microsoft Excel displays it in scientific notation. For example,
when you enter the number 1231231231234 in a cell, Excels displays 1.23123E+12. No matter how large you make
the cell width, Excel still displays a number larger then 12 characters in
To display the number in a format other than scientific
notation, you need to reformat the cell(s). Here’s how:
the cells that will hold the larger values and right-click the selection.
- In the
Number tab, select the desired format (e.g., Number) and click OK.
Now when you enter the values that have more than 12
characters they will be formatted as numbers and not scientific notation.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays