On 08/03/2009 16:06, Walter Hildebrandt wrote:
=A1 does not work because B1 will not be empty when A1 has a 0 in it.
On Sun, Mar 8, 2009 at 10:01 AM, Michael Adams <[email protected]>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.
In B1 type
=a1
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.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
