On 08/03/2009 19:31, Brian Barker wrote:
At 18:41 08/03/2009 +0000, Harold Fuchs wrote:
On Sun, 08 Mar 2009 09:51:22 -0600
Came this utterance formulated by Walter Hildebrandt to my mailbox:
Sorry for the confusion. i will try again.
If A1 is empty or has an 0 in it, I want B1 to be empty. At the
same time if A1 has any number in it, I want B1 to have that number
in B1.
Format column B to have no leading zeros:
* Right click in the column heading
* Select Format Cells
* In the middle of the panel that opens is a box labelled "Leading
zeros"; change the value to 0.
Done.
This is an interesting alternative technique. It is worth mentioning
that there is an important difference here (of which I imagine you are
aware). With the earlier solutions, the B cell is genuinely empty,
whereas in your scheme it has a zero value which is arranged to
display as if empty. This could have ramifications, of course, in any
other cells which make use of such values. If we put =B1 into C1, for
example, the earlier techniques produce another empty cell, whereas
yours produces an explicit zero (which obviously could be suppressed
in the same way). Either could be preferable.
(For the avoidance of doubt, this is an observation, not a criticism!)
Brian Barker
Criticisms are OK too :-)
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
