The formula will give you the product of A1 and 100, and so is equivalent to
=100*A1.
I'm not convinced that you intended to do that.
--
David Biddulph

"Claude" wrote in message
...
I have a list of number all starting with the first three numbers 011,
which
I need to remove completely from the rest of the numbers. Normally I
would
remove them with =product(a1:a1,100), however it is not working. Do I
have
something wrong with the formula? The list of numbers are located in row
A1
to A13,000 in my excel 2007 file, I am placing the formula in cell B1. If
someone can help me out I would really appreciate it.