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

Nevermind. Apparently no merging can be anywhere near any of these forsaken cells. Why can't this just be simple like Photoshop????

Sorry to bother you!

Originally Posted by Frustrated Word User

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

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

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