jenn
Perhaps they are inserted "bullets" from him entering ALT + 0149(Arial font)
or ALT + 0108(Wingdings font).
To see what they are, delete all but the character from the cell then in an
adjacent cell enter
=CODE(cellref) to get a number.
If you know the number you can EditReplace
what: ALT + 0149(example only)
with: nothing
NOTE: the number 0149 must be typed on the NumPad at right side of keyboard.
If no joy, download Chip Pearson's Cellview add-in to see what's in there.
http://www.cpearson.com/excel/CellView.htm
Gord Dibben Excel MVP
On Tue, 1 Feb 2005 17:09:03 -0800, "jenn"
wrote:
Hi,
When my supervisor creates spread sheets and sends them to me some of the
cells have a little black dot at the beginning of the cell. It is right at
the beginning and not a perfect circle and it is touching the left line of
the cell.... what is it... more importantly... How do I get rid of them?