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

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

This can be done using the format cell function. Go to Format, cells, Custom.
Now click on the menu bar at the top of the choices and type 00###0.

"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