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.