ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Display Leading Zero (https://www.excelbanter.com/excel-discussion-misc-queries/166656-display-leading-zero.html)

WLMPilot

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

Thanks,
Les

Kevin B

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



All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com