"Dots" in Excel 2003

[BadThad]

My boss has these "dots", more like hexagons when you zoom view, appear randomly in some of his Excel sheet cells. This only happens when he opens a file and not always. The only way to get rid of them is to copy the column, delete the old and then insert the copy.

Link to Pic

You cannot delete these and they aren't "officially" in the cell, we both have been pretty advanced users of Excel for over 15 years, but this has us perplexed. Anyone else experience these? Must be an Excel bug or we're missing something.

 

[BadThad]

Nobody?

 

[Malak]

Well it'd help if we knew which excel you use..

I would guess either your cell isn't large enough(but that's ### in mine) or wrong data for the format type maybe. Then again, it could very well be a bug, I've encountered some strange ones myself in Excel. Excel can be very aggravating.

 

[BadThad]

Originally posted by: Malak
Well it'd help if we knew which excel you use..

I would guess either your cell isn't large enough(but that's ### in mine) or wrong data for the format type maybe. Then again, it could very well be a bug, I've encountered some strange ones myself in Excel. Excel can be very aggravating.

Per thread title:

"Dots" in Excel 2003

There's NO data nor references nor fomulas in the cells....nothing at all, doing a clear all won't even remove these "dots".

 

[wkinney]

What is the 'category' of the cells (CTRL-1, Number tab)?

 

[BadThad]

It's independent of formatting. Funny thing too, there's not even an ASCII character for that symbol.

 

[PowerEngineer]

Do you see the same thing when you open the spreadsheet on your PC?

If you save the file off to another hard drive, does it do the same thing?