Andreas Saeger wrote:
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.
Ah, it is formatted as text, as you can see from my reply to Dan, so I
guess that explains it...sort of. But what's the rationale behind not
letting me concatenate the text foratted cells? I frequently want to
concatenate several text fields or do a variety of manipulations on text
formatted fields. Or am I misunderstanding something?
Thanks,
Carl
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
