View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Display Leading Zero

Select the cells you need to format then click FORMAT/CELLS in the menu. If
necessary, click the NUMBER tab and in the CATEGORY panel select CUSTOM. In
the TYPE field replace GENERAL w/the following format:

000

Click OK to complete the formatting.
--
Kevin Backmann


"WLMPilot" wrote:

I need to format cells to display the leading zero. The cell will hold a 3
digit heading, ie 050, 270, etc.

Thanks,
Les