Works: How to Show Leading Zeros with, for Example, Zip Codes

ID: Q76173

The information in this article applies to:

SUMMARY

This article explains how to show leading zeros in Works database fields or spreadsheet cells.

Works 4.0, 4.5, and 4.5a

To show leading zeros in Works 4.0, 4.5, or 4.5a database fields:

  1. On the Format menu, click Field.


  2. In the Format box, click Number.


  3. In the Appearance box, click 01235, and select 5 for the Number Of Digits.


To show leading zeros in Works 4.0, 4.5, or 4.5a spreadsheet cells:

  1. On the Format menu, click Number.


  2. In the Format box, click Leading Zeros.


  3. In the Number Of Digits box, click 5.


Works 3.0

To show leading zeros in Works 3.0 database fields or spreadsheet cells:

  1. From the Format menu, choose Number.


  2. From the Format list, choose Leading Zeros.


  3. In the Number Of Digits box, type 5.


Works 2.0 and 2.0a

When you enter zip codes into Works 2.0 database fields or spreadsheet cells, the leading zeros for zip codes will not display.

To make these entries show leading zeros:

  1. From the Format menu, choose Leading Zeros.


  2. Enter the number of digits to be displayed. For standard U.S. zip codes, set the number of digits to 5.



MORE INFORMATION

For example, the zip code 07654 will appear as 7654 in Works for Windows prior to using the above steps. After following the steps above, it will display all five digits and appear as 07654.

Note that because 9-digit (5+4) zip codes are treated as text due to the hyphen character, 9-digit zip codes will automatically retain any leading zeros.

Additional query words: 2.00 2.00a 3.00 4.00 4.00a 4.50 4.50a w_works db ss fmt 


Keywords          : 
Version           : WINDOWS:3.11,95; WINDOWS|MACINTOS:2.0,2.0a,3.0,4.0,4.0a,4.5,4.5a
Platform          : WINDOWS WINDOWS|MACINTOS 
Issue type        : kbinfo

Last Reviewed: July 6, 1999