![]() |
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 |
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