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]
