If they're apostrophes, maybe they're there to tell excel to treat the value as
text.

You may be able to hide them by:
tools|options|transition tab|uncheck Transition navigation keys.

These can be very useful if you want to enter 7-18 and not want excel to change
it to a date. (Using '7-18 (or preformatting the cell as text) will stop excel
from seeing that entry as a date.)

jdelcour wrote:

Hello All,

Some of the cells of a workbook contain either an apostrophe or a comma
on the left but do not appear in the formula bar. I have tried to get
rid of them by changing the style, format or template but they keep on
showing up.
Any idea how to delete these weird characters ?

Many thanks in advance,

Joe

--
jdelcour
------------------------------------------------------------------------
jdelcour's Profile: http://www.excelforum.com/member.php...o&userid=36496
View this thread: http://www.excelforum.com/showthread...hreadid=562527

--

Dave Peterson