Hoping someone can help me out here - I'm working on a project where I need
to include some squared numbers. It seems that regardless of the function or
formula I use, my answer is never actually right.

I've formatted all cells as numbers, so I don't think that's having an
impact. However, say that in cell C4, I have the number '20'. In D4, I type
any of the following:

=POWER(C4,2)
=PRODUCT(C4,C4)
=C4^2

Regardless of which formula I use, I end up with the answer 416.16, despite
the fact that the square of 20 is 400.

Short of just entering =20^2, is there anything someone can spot or suggest
that might help me fix this?