Beyond the Help files . . .



Access    Excel  FrontPage  Outlook  PowerPoint   Word     Miscellaneous    Tutorials    Windows    Free Downloads



Show Leading Zeroes in Microsoft Excel

There are a number of ways to perform this.

If you already have data.

Choose the cells, column, or row. Go to FormatCells. On the Numbering tab, choose Custom under Category, and in the Custom dialog box, type the number of digits you want to use in your data, thusly:

The above example would be for 7-digit account numbers or check numbers, etc. Zip codes can use the built-in Special format, so choose Special instead of Custom.

If you don't have any data yet, you can simply format your range as Text.

If you just want to enter a few cells with leading zeroes, there's no need to format the cells specialyou can just type an apostrophe before you enter the values.


Back to top...



All contents copyright Anne Troy 2005-2006