It is used to force numeric data into text format, often happens when
imported from other apps.

To clear it, in the VBIDE run this bit of code

Selection.Value = Selection.Value

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jonasa" wrote in
message ...

I have a sheet with heaps of cells with the content
'3
'5
'2
..

The cells are displayed with a small green triangle in the upper left
corner.

First: What does this format mean and what is it used for?

Second: To search and replace using ~' does not work for this
particular case.

How can I get rid of all the ' in the cells and replace them with an
empty space to make the cells in to numbers?

There are heaps of referlas to ~ for search of non character strings,
e.g.
http://www.excelforum.com/showthread...hlight=replace
but I can not find anything about this.


--
jonasa
------------------------------------------------------------------------
jonasa's Profile:
http://www.excelforum.com/member.php...o&userid=31722
View this thread: http://www.excelforum.com/showthread...hreadid=514316