| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 named ranges - how to use as function parameter?
Specific case: back in Excel 2003 days, I could have column A = a few decimal
numbers. I named column A "Counter". In column B I could enter the formula =dec2bin(Counter,6) and each cell gave me the binary representation of the corresponding cell in column A, just as expected. The same exact thing in Excel 2007results in a #VALUE! error. I expected Excel 2007 to do everything that Excel 2003 could. Why does this happen and how do I fix it? Regards GS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Named Ranges | Excel Discussion (Misc queries) | |||
| How do I set up a Dynamic Named Ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
| Named Ranges Disappearing in Excel 2007 | Excel Discussion (Misc queries) | |||
| Named ranges in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 Beta-Named Ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
