#7420 - Sorry, I hate metacomments and normally never do them, but there's a quick fix for that spreadsheet in which some names are entered into cells as ="Name".
Basically, you copy the data and use "Paste special" to paste it (into a new column, or I suppose you could save time and post it over the top of itself) and only paste values.
This way, plain text will stay plain text, and those pointless formulae will be pasted as their resultant value only (also plain text).
Hope this helps!
Sorry everyone, helpdesk instincts kicked in. Had to share my solution. :)