Hi here an example to solve your probleme
sincerely Franz Harold Fuchs schrieb:
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 =a1Format 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.
test.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
