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