| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
decimal number convert to 16bit binary
My column A fill with decimal numbers, I want it to be converted 16 bit
binary and each binary bit go to each column. Anybody can give some teach,thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
decimal number convert to 16bit binary
Peter,
Here's one way : Dim i As Long With ActiveCell For i = 0 To 15 .Offset(0, 16 - i).Value = -1 * ((.Value And 2 ^ i) 0) Next End With NickHK "Peter Cheang" wrote in message ... My column A fill with decimal numbers, I want it to be converted 16 bit binary and each binary bit go to each column. Anybody can give some teach,thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
decimal number convert to 16bit binary
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert binary to decimal | Excel Discussion (Misc queries) | |||
| Convert Binary to Decimal using IF and Sum Functions? | Excel Worksheet Functions | |||
| How can I convert binary numbers to decimal when they are larger . | Excel Worksheet Functions | |||
| convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
| How to convert a decimal number to a non-decimal number? | Excel Worksheet Functions | |||
![Peter Cheang[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
