Thread: Create number format for 4 digit integer preceded by zero
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar
 
Posts: n/a
Default Create number format for 4 digit integer preceded by zero
Under Cell Formatting, select Custom and enter: 0000

HTH,
Elkar


"Headfish" wrote:

I have a field with a bunch of numbers from 1 to 1000. They need to be
displayed as 0001, 0002...0999, 1000. I was looking for a function or number
formatting way of accomplishing this.
Reply With QuoteReply With Quote