Another thing you can do is use the TRIM() function to remove
apostrophes...then copy, paste special values...

Dave

On Dec 21, 3:20*pm, jmerwamer
wrote:
Hi Chuck,

I changed the formatting and it didn't go away. For my spreadsheets, it is
usually a green tab that indicates if a cell is formatted for text when it
contains numbers.
But in this case the cell will look normal like this with nothing around it:

Example

but in the function bar it will contain:

'Example

Any other thoughts?

Thanks,
Jamie



"CLR" wrote:
It's just an indication that the cell is formatted as TEXT. *Doesn't hurt
anything, doesn't print...........if you re-format the cell for a NUMBER
format, it should go away.

Vaya con Dios,
Chuck, CABGx3

"jmerwamer" wrote:

Some lines of my spreadsheet will have an apostrophe before the entry. It's
not visible except in the function bar. Find and replace doesn't see it. I
didn't put it there.- Hide quoted text -

- Show quoted text -