Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • 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

  • Thread starter Thread starter -
  • Start date Start date
Status
Not open for further replies.

Guest
Is there a formula to convert a hexadecimal string into an integer?
 
Sort by date Sort by votes
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]
 
Upvote 0 Downvote
Found in the PASTE FUNCTION - ENGINEERING category. [wink]
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
My error...typnig TOO literally....
Thanks jproj
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

3DDave
  • Locked
  • Question Question
Python now integrated into Excel - apparently
Replies
8
Views
1K
IDS
IDS
drawoh
  • Locked
  • Question Question
Insert Custom Info into Excel Footer
Replies
6
Views
474
drawoh
drawoh
Trenno
  • Locked
  • Question Question
Merging Unique Cells Into Unified Headings
Replies
13
Views
730
SkipVought
SkipVought
raviprakash369
  • Locked
  • Question Question
Need special formula for data entry
Replies
19
Views
602
raviprakash369
raviprakash369
Ralph2
  • Locked
  • Question Question
Break a vector into component forces
Replies
18
Views
595
IRstuff
IRstuff

Part and Inventory Search

Sponsor

Back
Top