display zero values at the beginning of a number.
 

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

display zero values at the beginning of a number.
 

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

display zero values at the beginning of a number.
 

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