display zero values at the beginning of a number.

[Barry Walker]

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

 

[Pete_UK]

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

 

[John Moore]

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.