Apply a Custom format to the cell, of "0000000", then you will always
have 7 digits showing, with appropriate number of leading zeros.

Hope this helps.

Pete

On Aug 18, 2:56*pm, Barry Walker
wrote:
I would like zero values at the start of a number eg.

0015624

that drops into a cell using a formula.

I know that if I type '0015624 then the first two zeros will be displayed..

if i type 0015624 into *a cell it will read 15624.

i would like to display zeros without having to type ' at the beginning so
that the formula reads true.

is this possible can some one help please

Thanks

basil