Thank you all for your replies. Johnny
2006/10/7, Terry <[EMAIL PROTECTED]>:
The only option left is ISBLANK (NOT isempty): =IF(ISBLANK(A1);"";A1) Johnny Andersson wrote: > Just want to correct what I just wrote: > *With your suggestions, this is what is viewed: > A1=Hey Man! => B1=Hey Man! > A1=375 => B1=375 > A1= => B1= > A1=0 => B1= > > *In the last case, nothing is shown in A1 or B1, but I guess that was > obvious... > > Regards > > > Johnny > > > > > 2006/10/6, Johnny Andersson <[EMAIL PROTECTED]>: >> >> Thank you both for your replies. However, both of your solutions has a >> minbor side effect: >> What about if, for example, A1 contains 0? >> >> This is what I want: >> In B1 I type: =A1 >> >> Now, I want A1 and B1 to show the following: >> A1=Hey Man! => B1=Hey Man! >> A1=375 => B1=375 >> A1= => B1= >> A1=0 => B1=0 >> >> Without doing anything, this is what is viewed: >> A1=Hey Man! => B1=Hey Man! >> A1=375 => B1=375 >> A1= => B1=0 >> A1=0 => B1=0 >> >> With your suggestions, this is what is viewed: >> A1=Hey Man! => B1=Hey Man! >> A1=375 => B1=375 >> A1= => B1= >> A1=0 => B1= >> >> >> The point is that I if A1=0, 0 should be what I see in B1. If A1 is >> empty, >> B1 should look empty too. >> >> >> Thanks anyway for your suggestions. At least I learned something new >> that >> might come handy in other situations. =) >> >> >> Regards >> >> >> Johnny >> >> >> 2006/10/6, Niklas Nebel < [EMAIL PROTECTED]>: >> > >> > Harold Fuchs wrote: >> > > 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. >> > >> > If you want to hide all zero values, you can also change the >> "Options - >> > Calc - View - Zero values" setting. >> > >> > Niklas -- If you're seeking, check out http://www.rci.org.au --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
