Leading Apostrophe

Don't put it in A1, as that's what gives a circular reference; put it in
another cell.
--
David Biddulph

"Phil-T" wrote in message
...
If I clicked on A1, and typed any of the functions shown below, it just
created a circular reference and blanked out the entire cell rather than
just
eliminating the leading apostrophe.

"Ms-Exl-Learner" wrote:

All the below function will clear the leading Apostrophe

=TRIM(A1)
=CLEAN(A1)
=SUBSTITUTE(A1,"'","")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Phil-T" wrote:

I was sent an Excel file and opened with my Excel 2003. And in every
field,
the data is prefaced with an apostrophe. When looking at the cell you
can't
see it and the apostrophe doesn't show up in print. Where is this
coming
from and how do I get rid of it.

One more guess.

If you change the cell format to Center-Aligned does the apostrophe change
to a Caret ^

ToolsOptionsTransition.

Make sure "Transistion Navigation Keys" is unchecked.


Gord Dibben MS Excel MVP

On Mon, 14 Dec 2009 06:45:01 -0800, Phil-T
wrote:

I was sent an Excel file and opened with my Excel 2003. And in every field,
the data is prefaced with an apostrophe. When looking at the cell you can't
see it and the apostrophe doesn't show up in print. Where is this coming
from and how do I get rid of it.

Edit Clear Formats should work,
or Copy and Paste formats from another cell.

You may need to reapply other formats after however.
There doesn't seem to be a way of removing this attribute
independently as the .prefixcharacter property is read-only.


"Phil-T" wrote:

I was sent an Excel file and opened with my Excel 2003. And in every field,
the data is prefaced with an apostrophe. When looking at the cell you can't
see it and the apostrophe doesn't show up in print. Where is this coming
from and how do I get rid of it.

Yeah!!! The EDIT / CLEAR / FORMATS did it!

Thanks to all for your efforts. Have never used this group before, but it
won't be the last time.

"Lori Miller" wrote:

Edit Clear Formats should work,
or Copy and Paste formats from another cell.

You may need to reapply other formats after however.
There doesn't seem to be a way of removing this attribute
independently as the .prefixcharacter property is read-only.


"Phil-T" wrote:

I was sent an Excel file and opened with my Excel 2003. And in every field,
the data is prefaced with an apostrophe. When looking at the cell you can't
see it and the apostrophe doesn't show up in print. Where is this coming
from and how do I get rid of it.

Pl mark the post as answered so that others can benefit from it.

"Phil-T" wrote:

Yeah!!! The EDIT / CLEAR / FORMATS did it!

Thanks to all for your efforts. Have never used this group before, but it
won't be the last time.

"Lori Miller" wrote:

Edit Clear Formats should work,
or Copy and Paste formats from another cell.

You may need to reapply other formats after however.
There doesn't seem to be a way of removing this attribute
independently as the .prefixcharacter property is read-only.


"Phil-T" wrote:

I was sent an Excel file and opened with my Excel 2003. And in every field,
the data is prefaced with an apostrophe. When looking at the cell you can't
see it and the apostrophe doesn't show up in print. Where is this coming
from and how do I get rid of it.