Number format need to display 0001 etc

Is there any way to format this other than formatting as text

I'd be grateful if anyone has an answer
--
Carys

Carys wrote:

> Is there any way to format this other than formatting as text
>
> I'd be grateful if anyone has an answer
> --
> Carys

Hi Carys

Select your cell range.

Format > Cells. Under Category, click Custom.

In the Type field, enter 0000. Click OK

Regards

Steve

Use a custom format of: 0000
??????

Carys wrote:
>
> Is there any way to format this other than formatting as text
>
> I'd be grateful if anyone has an answer
> --
> Carys

--

Dave Peterson

Thanks Steve
--
Carys


"[email protected]" wrote:

>
> Carys wrote:
>
> > Is there any way to format this other than formatting as text
> >
> > I'd be grateful if anyone has an answer
> > --
> > Carys
>
> Hi Carys
>
> Select your cell range.
>
> Format > Cells. Under Category, click Custom.
>
> In the Type field, enter 0000. Click OK
>
> Regards
>
> Steve
>
>

Thanks Dave.

Works a treat
--
Carys


"Dave Peterson" wrote:

> Use a custom format of: 0000
> ??????
>
> Carys wrote:
> >
> > Is there any way to format this other than formatting as text
> >
> > I'd be grateful if anyone has an answer
> > --
> > Carys
>
> --
>
> Dave Peterson
>