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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
