| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
decimal to binary conversion
wrote:
hello can you help fast ? tonight / How do I convert a decimal number 23.125 to binary? What do you mean by "binary"? Do you mean 10111.001 for 23.125? If so, what do you want for 24.05? Ostensibly, it is 11000.000011001100(1100)... (repeating the last 4 bits). 0.05 cannot be represented exactly in binary. Or do you really mean that you want the 64-bit binary floating-point representation? If so, hex representation might be best; for example, &h40380CCC,CCCCCCCD for 23.05. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I convert binary numbers to decimal when they are larger . | Excel Worksheet Functions | |||
| Decimal Conversion | Excel Discussion (Misc queries) | |||
| How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
| decimal point override does not work | Excel Discussion (Misc queries) | |||
| Decimal to Binary | Excel Worksheet Functions | |||
![joeu2004[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
