Hex entry into spreadsheets
Hex entry into spreadsheets
(OP)
Is there a formula to convert a hexadecimal string into an integer?
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS Come Join Us!Are you an
Engineering professional? Join Eng-Tips Forums!
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail. Posting GuidelinesJobs |
Hex entry into spreadsheets
|
RE: Hex entry into spreadsheets
Under TOOLS-ADDINS make sure the 'ANALYSIS TOOLPAK' is checked.
Then you can access the HEXTODEC converter.
Hope this helps...
RE: Hex entry into spreadsheets
RE: Hex entry into spreadsheets
It is actually called the "HEX2DEC" function and like meintsi said, it is in the "Analysis ToolPak". If you press F1 while in excel and type "HEX2DEC", excel help will tell you the steps to take.
Good Luck
jproj
RE: Hex entry into spreadsheets
Thanks jproj