Important information: this site is currently scheduled to go offline indefinitely by end of the year.
Excel in Hex hunt.
Excel in Hex hunt.
Excel can be a pretty nifty tool to convert Xex to Dec with the macro function like =HEX2DEC. This one, as the name indicates, will convert hex to decimal in Little Endian byte order. I was wondering though if there was some other spreadsheet function for floats ?
Going through my old posts and try update what I have learned since I posted the question. About that Excel thing maybe someone may find this helpful:
http://digilander.libero.it/foxes/xnumber_review_20.htm
I thought I 'd share.
http://digilander.libero.it/foxes/xnumber_review_20.htm
I thought I 'd share.
I was looking for spredsheet type conversion floats in one column and DEC values in another. Translating many floating point coordinates of vertices.Why don't you simply use a hex editor?
but ....
For now I DO, as no other option really found. List of them for some of the models gets to be pretty loooong.
I know its no Excel support forum, but maybe by chance someone from this community wuld be willing and able to help me sort out this perhaps pretty basic Excel task.
I have bunch of of numbers formated with 6 decimal places. I need to round each of them (up or down) to closest 1/8th (0.125) increment:
16.277790 = 16. 250000
18.745009= 18.750000
Call me thick, but I cannot figure how to do it .
I have bunch of of numbers formated with 6 decimal places. I need to round each of them (up or down) to closest 1/8th (0.125) increment:
16.277790 = 16. 250000
18.745009= 18.750000
Call me thick, but I cannot figure how to do it .
- Dinoguy1000
- Site Admin
- Posts: 786
- Joined: Mon Sep 13, 2004 1:55 am
- Has thanked: 154 times
- Been thanked: 163 times
-
- Site Admin
- Posts: 4073
- Joined: Wed Jan 15, 2003 6:45 pm
- Location: Dungeons of Doom
- Has thanked: 450 times
- Been thanked: 682 times
- Contact:
Nah, it's in Excel:
You can do this :
http://j-walk.com/ss/excel/usertips/tip011.htm
Or you can do this:
If you have Excel 2007 this function is in by deafult I believe.
I have attached a test sheet that does this. Check it.
You can do this :
http://j-walk.com/ss/excel/usertips/tip011.htm
Or you can do this:
In your case, you'd write MROUND(16.277790;0.125)Round to a Chosen Multiple
There is another round function in Excel that will round a number to the multiple we specify. This function is called MROUND. It is not available by default, so you need to go to Tools>Add-ins and check Analysis Toolpak.
=MROUND(22.5,10) will result in a value of 20
=MROUND(22.5,5) will result in a value of 25
If you have Excel 2007 this function is in by deafult I believe.
I have attached a test sheet that does this. Check it.
You do not have the required permissions to view the files attached to this post.