Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hex entry into spreadsheets

Status
Not open for further replies.

Guest
Is there a formula to convert a hexadecimal string into an integer?
 
Replies continue below

Recommended for you

First you have to initialize the toolpak.

Under TOOLS-ADDINS make sure the 'ANALYSIS TOOLPAK' is checked.

Then you can access the HEXTODEC converter.

Hope this helps...[reading]
 
Found in the PASTE FUNCTION - ENGINEERING category. [wink]
 
CrazyCarl:

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
 
My error...typnig TOO literally....
Thanks jproj
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor