The answer depends on how the ones are put there. If it is a text string
then put a 1 in a cell (any cell) and copy the 1. select this number or range
of numbers and then
Edit|Paste special - select multiply and click OK
If the zeros are the result of a format then simply re-format as a number.
I supposed that 0000010 is a text string. If you want to convert it to a
number (10) then
=VALUE(A1)
If you want to convert it to a text ("10") then
=TEXT(VALUE(A1),"@")
