If my original suggestion did not work then:

Tools Options Error checking and clear the number stored as text
checkbox
--
Gary's Student


"masonap" wrote:


I have read the reply from Gary's student.

This does not solve the problem, I still need to F2 on every cell in
order to see the small green triange in the top left corner of the cell
which confirms that the cell is formatted as text correctly.


--
masonap
------------------------------------------------------------------------
masonap's Profile: http://www.excelforum.com/member.php...o&userid=34783
View this thread: http://www.excelforum.com/showthread...hreadid=545398