Do you have the Analysis Toolpak add-in loaded?

Your #NUM! error may actually be #NAME!


Gord Dibben MS Excel MVP

On Wed, 12 May 2010 09:12:20 -0400, "Homey" <none wrote:

you say-

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

I try with dec2bin in excel 2003 and it not work. give #Num! error. work
okay with built in function like Round.

"Gershon" wrote in message
...
| 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