Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
faster way to convert hex to ieee754?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Tom Ogilvy, post: 6125397"] Probalby easier (and more intuitive to just pass in the Hex value since that is what the function claims to do) Type MyHex Lng As Long End Type Type MySingle sng As Single End Type Function Hex2Ieee754(i As Long) Dim h As MyHex Dim s As MySingle h.Lng = i LSet s = h Hex2Ieee754 = s.sng End Function Sub Test() Debug.Print Hex2Ieee754(&H40B80000) End Sub [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
faster way to convert hex to ieee754?
Top