Excel’s Stubborn Refusal to Display Superscripts

Who wants to look at 60.45E-3 when they can see 6O.45xl0-3 instead? While it is one of the most popular tools used by engineers on the planet, Excel’s formatting capabilities can leave a lot to be desired. Jon Titus was particularly peeved over the fact that it displays data in scientific format (ie 6.023E23) but that he couldn’t get it to produce exponents only in multiples of (E—3 , E—6, E—9, etc.) Think millivolts, microvolts, and nanovolts, and you get the idea. Rather than get mad, well at least not any more mad than he already was, Jon wrote a nifty little Excel macro, EngUnits, that not only produces information in an intuitive engineering format, but also allows an engineer to set the desired number of significant figures in the results.

Warning! Use of the macros below assumes knowledge of copying, pasting and formatting cells. The Excel macro, EngUnits, operates on a contiguous block of numeric values and converts them into text that appears in cells with: • superscript exponents, • powers-of–10 exponents, not E, and • multiple—of—three exponents (lO-3, 10-6, lO-9, and so on) The instructions also apply to the SciUnits macro in a separate Excel file. This macro produces integer exponents such as -2, -3, 7, etc.) Use these files and we guarantee your blood pressure to go down at least ten points!

Leave a Reply

Your email address will not be published. Required fields are marked *