Hi Hango,

- It sounds like it is formatted as text (eg won't include # in a
sum).

When you tried to delete it "but all attempts to get rif of
it like delete, or copy another cell, failed." did you just use the
delete key on the keyboard?
Try using the menus: Edit - Clear - All or [alt + E + A + A]
The delete key is just clearing the contents, whereas the "clear all"
approach removes formatting, comments, & contents.
(Although, if this is the issue then copying another cell onto it
should have the same effect.)

Is the sheet protected?
If so, try unprotecting the sheet & then using "clear all".

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=522514