Excel Leading Zeros

One way to display leading zeros in Excel is to use the Custom setting within the Format Cells > Number dialog rather than the Text setting.  Then enter zeros up until the length you need to be displayed.  For example, to show 0123, you'd enter 0000 in the Custom dialog box above the values list.  See this Microsoft support page for details.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.