"Alyssa" wrote:
Hi Max - I've tried everything you've suggested including reformatting the
whole sheet. It seems that here are no 'normal' cells anywhere in the sheet
as the =LEN(cellref) formula simply displays exactly as typed no matter how
many times I hit the enter button from within that cell. I did try this
formula in a new sheet and it returned an answer no problem. Could it be that
for some reason the whole worksheet has been infected?

unlikely .. but you could always scan the file with an anti-virus ..

What happens if you do an entire sheet copy (the problematic one), then
paste special as values into a new sheet? Then carry out the earlier
suggestions in the new sheet. Are you able to format the stubborn "4" in the
cell?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---