Have you tried a straight copy and paste to another cell? Doesn't the
C55 change relative to where you have copied it to?

Pete

On Sep 28, 10:51 am, Jeff wrote:
Hello,

I am using this formula to multiply all the digits in an integer:

=PRODUCT(VALUE(MID(C55,ROW(A1:OFFSET(A1,LEN(C55)-1,0)),1)))

So far so good...

But I want to copy this array formula for a large range of cells, each
with a different integer. But my understanding is that an array
formula must be the same for the range of cells. How can I get it to
update to different cells (C55 in the above formula, the next one is
C64, e.g.) like a regular formula?

Thanks,
Jeff