View Single Post
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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?