Thread: Number format need to display 0001 etc
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Carys Carys is offline
external usenet poster
  
Posts: 4
Default 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


Reply With QuoteReply With Quote