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