Prev: Zip Code Last 4 Digit as Zero
Next: Racking my brain on sumif
From: watermt on 3 Jun 2010 17:13
I was moving along very well gathering information form several other
worksheets in my workbook by using the = sign to display text from the
worksheets into a summary worksheet. All of a sudden I was see zeros (0)
instead of the text I anticipated seeing.

My cells are formatted the same (General), can someone possibly assist me on
this?
From: "David Biddulph" groups [at] on 3 Jun 2010 17:36
=IF(Sheet1!A1="","",Sheet1!A1)
--
David Biddulph


"watermt" <watermt(a)discussions.microsoft.com> wrote in message
news:B7DD9A52-C4A3-4872-BC01-1FBD03C6C427(a)microsoft.com...
> I was moving along very well gathering information form several other
> worksheets in my workbook by using the = sign to display text from the
> worksheets into a summary worksheet. All of a sudden I was see zeros (0)
> instead of the text I anticipated seeing.
>
> My cells are formatted the same (General), can someone possibly assist me
> on
> this?


From: Gary''s Student on 3 Jun 2010 17:57
Since you are seeing zero rather than an error, it is likely that the
destination links got scrambled. Verify the addresses.
--
Gary''s Student - gsnu201003


"watermt" wrote:

> I was moving along very well gathering information form several other
> worksheets in my workbook by using the = sign to display text from the
> worksheets into a summary worksheet. All of a sudden I was see zeros (0)
> instead of the text I anticipated seeing.
>
> My cells are formatted the same (General), can someone possibly assist me on
> this?
 | 
Pages: 1
Prev: Zip Code Last 4 Digit as Zero
Next: Racking my brain on sumif