On Tue, 2006-08-22 at 10:10 +1000, Bob Long wrote:
> 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)
> Just a quick note. If you have mixed contents, remember to use CHAR to handle numbers. -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/
smime.p7s
Description: S/MIME cryptographic signature
