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

Number format need to display 0001 etc
 

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

Number format need to display 0001 etc
 

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

Number format need to display 0001 etc
 

Thanks Steve
--
Carys


" 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

Number format need to display 0001 etc
 

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