You could do some thing like:
=CONCATENAR("Option ";M33)
(my version of OO is in Spanish, but I think you could find that function
easily)
Hope it helps.
Ely
2008/8/21 Mark Knecht <[EMAIL PROTECTED]>
> Hi,
> I'm looking at a prebuilt spreadsheet in Excel and trying to
> duplicate some of its functionality in OOCalc. I'm having trouble with
> one formatting issue. In Excel there is a cell that has the following
> contents:
>
> ="Option "&M33
>
> M33 is a cell that contains a number from 0-160. In Excel when M33 is
> 1 or greater Excel displays
>
> Option 1
>
> or whatever number is in cell M33. However when M33 is 0 Excel
> displays nothing. The cell is completely blank. It does not say Option
> 0.
>
> When I try to build this myself, in Excel or OOCalc I see Option 0
> in my version. How did the guy who created this spreadsheet get Excel
> to do this?
>
> I've checked all the formatting for the cell and I just don't see it.
>
> Thanks,
> Mark
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
