So will copying a blank cell and then Paste Special Add into the original
cell

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Dave F" wrote in message
...
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 -