Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE("0";G3)
where G3 is the column with zip codes. (The data was brought into a
numeric field, hence the leading zero fell off.) But this only shows
this formula in the cell, not the result. Note View Formulas is not
checked in the Calc Options.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
