Mysterious, undeletable zeros
 

Hello all,

I have a spread sheet that someone else set up. This person is no
longer available for assistance.

Here's the skinny. The spreadsheet is set up to count the number of
x's in a given column. The very last line of the column (Last two
actually) has two larger zeros that won't go away no matter what I try.
Keep in mind I have no idea what to try. I have made some minor
formatting changes to the document and before that, I don't think this
was happening.

I was having the same problem with another column, but solved that by
unmerging some cells. There are no cells to be unmerged here, and I
didn't touch anything down on line 200.

I would really appreciate any help. My boss is putting the pressure
on. He knows I don't know this program, but expects me to learn it.
If it would help, I could send the spreadsheet to take a look at too.

Thanks in advance.

Joanna




--
Frustrated Word User

Mysterious, undeletable zeros
 

Want to send me the file? To me, not the newsgroup, please. Remove
TRUENORTH.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Frustrated Word User" m
wrote in message news:Frustrated.Word.User.37db474@officefrustratio n.com...

Hello all,

I have a spread sheet that someone else set up. This person is no
longer available for assistance.

Here's the skinny. The spreadsheet is set up to count the number of
x's in a given column. The very last line of the column (Last two
actually) has two larger zeros that won't go away no matter what I try.
Keep in mind I have no idea what to try. I have made some minor
formatting changes to the document and before that, I don't think this
was happening.

I was having the same problem with another column, but solved that by
unmerging some cells. There are no cells to be unmerged here, and I
didn't touch anything down on line 200.

I would really appreciate any help. My boss is putting the pressure
on. He knows I don't know this program, but expects me to learn it.
If it would help, I could send the spreadsheet to take a look at too.

Thanks in advance.

Joanna




--
Frustrated Word User

Mysterious, undeletable zeros
 

If it is an .xls file (not .xlsx), then you can send it to me at:

pashurst <at auditel.net

Change the obvious.

Pete

On Dec 4, 3:04*pm, Frustrated Word User <Frustrated.Word.User.
wrote:
Hello all,

I have a spread sheet that someone else set up. *This person is no
longer available for assistance.

Here's the skinny. *The spreadsheet is set up to count the number of
x's in a given column. *The very last line of the column (Last two
actually) has two larger zeros that won't go away no matter what I try.
Keep in mind I have no idea what to try. *I have made some minor
formatting changes to the document and before that, I don't think this
was happening.

I was having the same problem with another column, but solved that by
unmerging some cells. *There are no cells to be unmerged here, and I
didn't touch anything down on line 200.

I would really appreciate any help. *My boss is putting the pressure
on. *He knows I don't know this program, but expects me to learn it.
If it would help, I could send the spreadsheet to take a look at too.

Thanks in advance.

Joanna

--
Frustrated Word User