Number format need to display 0001 etc

[Carys]

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

I'd be grateful if anyone has an answer

 

[britwiz]

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

I'd be grateful if anyone has an answer

Hi Carys

Select your cell range.

Format > Cells. Under Category, click Custom.

In the Type field, enter 0000. Click OK

Regards

Steve

 

[Dave Peterson]

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

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

I'd be grateful if anyone has an answer

 

[Carys]

Thanks Steve
--
Carys

Hi Carys

Select your cell range.

Format > Cells. Under Category, click Custom.

In the Type field, enter 0000. Click OK

Regards

Steve

 

[Carys]

Thanks Dave.

Works a treat
--
Carys

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