Andreas Saeger wrote:
> 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?
> When you format a cell as text it will treat any input as text, even if it
> is numeric or starting with a "=".
Is that really true? I've not been able to confirm that.
Anyway, I've also not been able to replicate the original problem which is
showing the formula rather than the result. Double check it is not something
simple like there being a space before the "=".
(Win XP, OOo 2.0.3)
--
Bob Long
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
