Microsoft's Excel spreadsheet provides a helpful tool for manipulating data, but sometimes its formatting capabilities don't cut it. Although Excel can display data in scientific format, for example, 6.023E23, you can't get it to produce exponents only in multiples of three, such as E-3, E-6, E-9, and so on. Think millivolts, microvolts, and nanovolts, and you get the idea.
Nor will Excel's built-in formats display exponents as superscripts, which may make interpreting data a hassle. Who wants to look at 60.45E-3 when they can see 60.45Χ10-3 instead? I grew frustrated at these limits and wrote an Excel macro, EngUnits, which not only produces information in engineering format, but it also lets you set the number of significant figures you want in the results. The macro, written in Excel's built-in Visual Basic, operates on a block of contiguous numeric values.
I stressed the macro converts numeric information into text that presents the information properly, so users can readily export the data as text to a Word, PowerPoint, or other document. The VB macro includes comments, so anyone with a bit of programming experience can change the macro to format information differently. Instead of trying to first learn VB from a book, I suggest engineers record a macro to perform a task and then look at the equivalent VB code Excel produces. The macros teach you a lot about how VB works on Excel information. The EngUnits macro is distributed under the terms of the General Public License (GPL): www.gnu.org/licenses/gpl.txt.
You need this trick if: You need to convert Excel values to engineering format that provides exponents in multiples of three and in superscript form. You can drop converted data into other software, such as Word, PowerPoint, a Web-page editor, or a desktop publishing program.
Tweet This
4 
