Format Zip Code - Leading Zero Missing 1

[dunkyn]

Zipcodes with a leading zero have been dropped in my database.

Is there a way to format the field so that 1234 appears as 01234, without adversely affecting zipcodes that do not start with the leading 0?

 

[IdoMillet]

Assuming your zip_code field is numeric, use the following formula:
-------------------------------------
Cstr({zip_code},"00000&quot
-------------------------------------

Cheers,
- Ido


CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dunkyn]

Just what I needed. Thank you!

What does Cstr stand for? I like to understand what I'm doing, other than reformatting a number?

 

[IdoMillet]

Cstr() and ToText() convert stuff to string/text.
Lots of detail on optional arguments (such as the formatting string argument) in Online Help.

Cstr stands for "Convert to String".

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dunkyn]

Thank you.