Number Cells Deleting 0s

I need to store some numbers, all of which are prefixed by four or five zeros. When I format the cells as number, the zeros are erased. So, 0000012345 becomes 12345. The zeros are preserved when I store them as text, but I cannot do the functions that I need to do with the cells formatted as text.

Does anyone know how I can preserve the zeros in number format?

It is as simple as that...
select all cells which you want to suffix by zeros..
Right click and select format cells...
click custom formats...
then in the "type" tab...
write as many zero you wish to suffix....


Say thanks, Click *