CarlP wrote:
Trying to add a leading zero on eastern US zip codes using the
Concatenate function as follows:
=CONCATENATE(0;G3)
and
=CONCATENATE("0";G3)
Your cell is formatted as text or Tools>Options>Calc>View>"Show
Formulas" is checked.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
