Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IntToHex Error
I have a list of decimals ie. Cell B1 = .52399 and I would like to format
these cells to view them multiplied by 100000 and converted to Hex. So I have used the formula =INTTOHEX(B1*100000). This formula almost works but it is off. It should give me a HEX value of CCAF however it gives me a value of CCAE!!! I think this might be because INT seems to have a round down function of some sort. Is there anything I do to fix this?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |