CarlP wrote:
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
When you format a cell as text it will treat any input as text, even if
it is numeric or starting with a "=".
You may use shorter "0"&G3 instead of CONCATENATE.
If G3 is a number 12345, then =TEXT(G3;"0000000") converts to text 0012345.
If G3 is a numeric text "12345", then =TEXT(VALUE(G3);"0000000")
converts to text 0012345.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
