Leading zero's

Hi

How can I get Excel2002 to display two leading zero's in a cell (as in the
time 00.20) I have tried to use the formatting option but can't seem to the
solution anywhere

MTIA

Elwyn

Elwyn,

If you just mean precede any number with 00., then use a format of

"00."0

--
HTH

Bob Phillips

"elwyn" <pro4x@btinternet.com> wrote in message
news:ddlv2a$2os$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com...
> Hi
>
> How can I get Excel2002 to display two leading zero's in a cell (as in the
> time 00.20) I have tried to use the formatting option but can't seem to
the
> solution anywhere
>
> MTIA
>
> Elwyn
>
>