On Friday, October 06, 2006 3:17 PM [GMT+1=CET], Johnny Andersson <[EMAIL PROTECTED]> wrote:
> Hi! I'm using OpenOffice.org 1.1.5 (slow PC from 1998, if anyone > wonders why), but that shouldn't have anything to do with my question. <snip> > The problem is when you do something liuke the following example: > > A1 contains nothing. > B1=A1 > > Now B1 shows 0. If A1 is nothing, I want B1 to show nothing... > <snip> In 2.0.3, which I'm using, you can change the default format for numbers to have no leading zeros. If I do this then your problem goes away. To change the format go to Format>Styles and Formatting; choose Cell Styles (the leftmost icon); *right* click Default; click Modify. About 2/3 down is a box labelled "Leading zeros". Change this to 0, click OK and close the Styles and Formatting pane. Done. I am assuming this, or something along these lines, will work in 1.1.5. Harold Fuchs London, England --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
