Using Hex values in Excel?

Article View: comp.windows.ms

Article #11474

#11474

From: Bob Weiman
Date: Thu, 02 May 1991 18:12

13 lines
973 bytes

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

Technical Details

Message-ID: <1991May2.181210.7361@netnews.whoi.edu>

Path: arc1-ca.pugleaf.net!utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!ncar!netnews.whoi.edu!news

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!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