| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
BIN2DEC conversion for large binary numbers
Hello All,
I need your help, i want to convert large binary numbers using excel but whenever i use the BIN2DEC function the result is negative which is not correct. Ex. BIN2DEC(1100110110) the result is -202 but if i use the calculator the result is 822 which is the correct value Any ideas? what shall i do to have the correct value? Thanks in advance A.M. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal to binary conversion | Excel Worksheet Functions | |||
| Binary Numbers | Excel Discussion (Misc queries) | |||
| decimal to 16 bits binary conversion in Excel? | Excel Worksheet Functions | |||
| Solver returns non binary answer in binary constrained cells | Excel Worksheet Functions | |||
| large binary numbers | Excel Worksheet Functions | |||
Threaded Mode
