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
|