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?

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?

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson

there are not pictures or triangle note marks or anything... when I tried
your suggestion there was nothing in the 'preview' box...


"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson

I don't have any other guesses.

If you hit the delete key with the offending cell selected, nothing changes?

jenn wrote:

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson


--

Dave Peterson

If I copy the offending cell to a clean cell... it copies the dot. If I copy
a clean cell into the offending cell it stays.

"Dave Peterson" wrote:

I don't have any other guesses.

If you hit the delete key with the offending cell selected, nothing changes?

jenn wrote:

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson


--

Dave Peterson

How about hitting the delete key?



jenn wrote:

If I copy the offending cell to a clean cell... it copies the dot. If I copy
a clean cell into the offending cell it stays.

"Dave Peterson" wrote:

I don't have any other guesses.

If you hit the delete key with the offending cell selected, nothing changes?

jenn wrote:

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Could they be error indicators?

Choose ToolsOptions
On the Error Checking tab, remove the check mark from
'Enable background error checking'
Click OK

Dave Peterson wrote:
How about hitting the delete key?



jenn wrote:

If I copy the offending cell to a clean cell... it copies the dot. If I copy
a clean cell into the offending cell it stays.

"Dave Peterson" wrote:


I don't have any other guesses.

If you hit the delete key with the offending cell selected, nothing changes?

jenn wrote:

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:


How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:


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?


--

Dave Peterson


--

Dave Peterson





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

If I delete is stays... if I type other characters it stays

"Dave Peterson" wrote:

How about hitting the delete key?



jenn wrote:

If I copy the offending cell to a clean cell... it copies the dot. If I copy
a clean cell into the offending cell it stays.

"Dave Peterson" wrote:

I don't have any other guesses.

If you hit the delete key with the offending cell selected, nothing changes?

jenn wrote:

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

and if you set the format to General, what happens?

(a rewording of a previous check)

jenn wrote:

If I delete is stays... if I type other characters it stays

"Dave Peterson" wrote:

How about hitting the delete key?



jenn wrote:

If I copy the offending cell to a clean cell... it copies the dot. If I copy
a clean cell into the offending cell it stays.

"Dave Peterson" wrote:

I don't have any other guesses.

If you hit the delete key with the offending cell selected, nothing changes?

jenn wrote:

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

it is already set to general. I put it to number and then back to general and
still... the elusive black dot.

"Dave Peterson" wrote:

and if you set the format to General, what happens?

(a rewording of a previous check)

jenn wrote:

If I delete is stays... if I type other characters it stays

"Dave Peterson" wrote:

How about hitting the delete key?



jenn wrote:

If I copy the offending cell to a clean cell... it copies the dot. If I copy
a clean cell into the offending cell it stays.

"Dave Peterson" wrote:

I don't have any other guesses.

If you hit the delete key with the offending cell selected, nothing changes?

jenn wrote:

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson

Can you copy that cell to a worksheet in a new workbook -- a single cell
worksheet?

If it still shows the trouble there, if you want you can send that very small
workbook to me (not the group!).



jenn wrote:

it is already set to general. I put it to number and then back to general and
still... the elusive black dot.

"Dave Peterson" wrote:

and if you set the format to General, what happens?

(a rewording of a previous check)

jenn wrote:

If I delete is stays... if I type other characters it stays

"Dave Peterson" wrote:

How about hitting the delete key?



jenn wrote:

If I copy the offending cell to a clean cell... it copies the dot. If I copy
a clean cell into the offending cell it stays.

"Dave Peterson" wrote:

I don't have any other guesses.

If you hit the delete key with the offending cell selected, nothing changes?

jenn wrote:

tried your suggestion... there is nothing in the 'sample; box or the cell,
but this funny little black fussy dot...

"Dave Peterson" wrote:

How about a leader (like in a table of contents)?

Select an offending cell
format|cells|number tab
Do you see something like:

*.@
in the Type box (where you specify your custom number format)?

The asterisk says to repeat the next character (dot in my case) until you get to
the value in the cell.

(Works nicely when the cell is right justified and the cell is wide enough.)

But with nothing (not even a space), I don't see the leaders.

(You don't have any pictures floating above that cell, do you?)

jenn wrote:

they are not bullets... they aren't even perfect circles or squares. They are
sort of fuzzy, az well. I download the cell view as you suggested and there
is nothing in the cell... it's just crazy

"Gord Dibben" wrote:

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?



--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson