Office 97 Tips

Getting Converted

Since much of the world expresses its temperatures in centigrade (or Celsius) and we in the USA most often use Fahrenheit, having a way to quickly switch between the two can be helpful. Excel 97 comes to the rescue with a command named CONVERT. To see how it works, type 68 into cell A1. Now move to cell A3 and type in =CONVERT(A1, "F", "C") and press Enter. This formula converts Fahrenheit (F) to Centigrade (C) and the result should be 20. If you need to convert from Centigrade to Fahrenheit, type in =CONVERT (A1, "C", "F") and press Enter. If you left 68 in A1, the new result should be 154.4. Note: if the Convert function doesn't work for you, choose Tools|Add-Ins. Make sure the Analysis ToolPak option is turned on and click on OK.


Return to the Program Tips index


FAQ Articles DirectX Plus98! Downloads Drivers News Archive
Home, Links, Awards, Help, Map, Poll, Newsgroups, Online Chat, Mailing List, Search
Tips & Tricks Guides Bugs & Fixes Themes Reviews Site Contents ActiveIE

HR Line

Copyright (C) 1998-1999 The Active Network. All rights reserved.
Please click here for full terms of use and restrictions.