I have a range formatted as 00000000. When I type 354 in a cell, I get
00000354 as expected. No problem.

When I use the Analysis Pak function = DEC2BIN(1), I get 1 instead of
the desired 00000001. A different function for example =SUM(1, 5)
works as expected and gives me 00000006.

How can I do this without VBA? Thanks