WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Scientific Notation in Excel

Scientific Notation in Excel

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Excel Scientific Notation

Scientific Notation in excel is a special way of writing small and large numbers which helps us to compare and use the same in calculations.

How to Format Scientific Notation in Excel? (with Examples)

You can download this Scientific Notation Excel Template here – Scientific Notation Excel Template

Example #1 – For Positive Exponent

Now we will see how to work on excel with the formatting of scientific notation. Below are the data for this example that I use. Copy the above number list and paste it into your worksheet area.

Scientific Notation in Excel Example 1

Copy and paste the first column numbers to the next column.

 Example 1.0

Now by selecting the range, click on the drop-down list in excel of “Number Format.”

Scientific Notation in Excel Example 1.1.1

At the bottom, you can see the “Scientific” formatting option. Click on this to apply this formatting.

 Example1.2.0

Now scientific formatting is applied to large and small numbers.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Scientific Notation in Excel Example1.3

Now take an example of the first instance. General formatting number was 4750528335 and scientific number is 4.75E+09 i.e. 4.75 x 109 (10 * 10 * 10 * 10 * 10 * 10 * 10 * 10 * 10).

 Example1.4

Now look at A6 cell value, general formatting value was 49758 and scientific value is 4.98E+04 i.e. 4.98 * 104 (10 * 10 * 10 * 10).

Scientific Notation in Excel Example1.5

As you can see, the decimal value should have been 4.97; instead, it shows as 4.98. This is because after two digits of decimal third digit value is “5,” so it is rounded to the nearest number, i.e., instead of 97, it will be 98.

Example1.6

If you don’t want to see this rounding off to the nearest values, then you can increase the decimal value from 2 to 3 digits.

Scientific Notation in Excel Example1.7

Now we can see scientific numbers in three-digits.

Example1.8

Example #2 – For Negative Exponent

You need to know how negative exponent works with excel scientific notation. Now, look at the below image.

Scientific Notation in Excel Example2

First value is 0.0055 which is formatted as 5.5E-03 i.e. 5.5 x 10-3

Example2.1

Now look at the second number 4.589, which is formatted as 4.6E+00, i.e., 4.6 x 100

Scientific Notation in Excel Example2.2.0

Things to Remember

  • First, you need to understand how scientific notation works in mathematics and then learn the same in excel.
  • We can only change the decimal values like 2, 3, and 4 digits.
  • Excel uses scientific format automatically for large and small numbers of 12 digit values or more.

Recommended Articles

This has been a guide to scientific notation in excel. Here we discuss how to use scientific formatting in excel for positive and negative exponent along with examples and downloadable excel template. Below you can find some useful excel VBA articles –

  • Text Formatting in Excel
  • New Line in Excel Cell
  • Exponential Smoothing in Excel
  • EXP Excel Function
  • Data Model in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Scientific Notation Excel Template

Special Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More