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]
