| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
decimal to 16 bits binary conversion in Excel?
I'm aware of the function DEC2BIN(), but it has a limitation of 10 bits. Are there any 16 bits solutions available? -- xcgames ------------------------------------------------------------------------ xcgames's Profile: http://www.excelforum.com/member.php...o&userid=32842 View this thread: http://www.excelforum.com/showthread...hreadid=526353 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
decimal to 16 bits binary conversion in Excel?
xcgames said the following on 3/26/2006 2:20 PM:
I'm aware of the function DEC2BIN(), but it has a limitation of 10 bits. Are there any 16 bits solutions available? See this post you may need to use VBA and break it up. http://www.dailydoseofexcel.com/arch...mal-to-binary/ |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
decimal to 16 bits binary conversion in Excel?
Try this =DEC2BIN(A1/256,8)&DEC2BIN(MOD(A1,256),8) always shows 16 bits... -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=526353 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Point Excel 2003 | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
| Excel 2003 to 95 File format conversion | Excel Discussion (Misc queries) | |||
| Numbers after decimal point excel to word mail merge | Excel Worksheet Functions | |||
Linear Mode
