This video shows how to format a number into engineering notation in Microsoft Excel.
Engineering notation is a version of scientific notation with the difference that the exponent is raised to a power which is divisible by 3.
By putting a number in Engineering notation, the prefixes such as milli, kilo, mega, giga etc are more easily conveyed at glace value.
The custom code for engineering notation in custom formatting in Excel is: "##0.0E+0"
Timestamps
0:00 What is engineering notation
0:19 Why is engineering notation important
0:29 How to create engineering notation in Excel