Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!ncar!netnews.whoi.edu!news From: weiman@jargon.whoi.edu (Bob Weiman) Newsgroups: comp.windows.ms Subject: Using Hex values in Excel? Message-ID: <1991May2.181210.7361@netnews.whoi.edu> Date: 2 May 91 18:12:10 GMT Sender: news@netnews.whoi.edu Distribution: usa Organization: Woods Hole Oceanographic Institution Lines: 13 Is there a way in Excel to use Hex numbers in a spreadsheet? Maybe a macro to convert decimal to hex and back? I need to calculate gains for a motor controller for one of our underwater vehicles and to burn the Hex values into PROM. Since these will change with different loads, I am setting up a spreadsheet to Calculate the gain values. I would be nice if I could display the values in Hex. -- Bob Weiman Internet: bweiman@whoi.edu Woods Hole Oceanographic Institution Deep Submergence Lab Woods Hole, MA