Information • Textbooks • Media • Resources edited by
JCE WebWare
William F. Coleman
Abstracts of Recent Articles
Wellesley College Wellesley, MA 02481
W
Randall J. Wildman University of Wisconsin–Madison Madison, WI 53715
Christopher King, Department of Chemistry, Troy State University, Troy, AL 36082
A chemistry formatter is software that does some of the formatting a chemist would otherwise have to do by hand. Chemistry formatters for Microsoft Excel and Word are provided that perform the five functions described below.
appears. The formatters are written in Visual Basic and are packaged as add-ins. The code is not protected, making these add-ins possible templates for new add-ins. A macro and 19 “AutoCorrect” entries are also provided, which can easily be added or removed. After these entries are installed, Word will automatically convert, for example, pKa to pKa, Dgo to ∆G°, . Co-60 to 60Co, and is converted to →. 5. Numbers in the form of 3.2E8 are converted to 3.2 ⫻ 108.
Users select the material to be formatted, click the chemistry formatter button, and the reformatted material
JCE WebWare
896
Figure1. Results of applying the chemistry formatter to cells in an Excel spreadsheet. To run the formatter, users select cells (or other objects), and then click the chemistry formatter button (the O 2 2- button shown at the top).
http://jchemed.chem.wisc.edu/JCEWWW/Features/WebWare/
Journal of Chemical Education • Vol. 79 No. 7 July 2002 • JChemEd.chem.wisc.edu
