Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to display the string "-Inf" in a cell in Excel (Microsoft Office Standard 2010).

However, the cell displays the string "#NAME?" instead.

How can I alleviate this?

I have set the type of all cells to "text - Text format cells are treated as text even when a number is entered in the cell. The cell is displayed exactly as entered", so I am a bit surprised that it doesn't actually display the text exactly as entered.

share|improve this question
up vote 1 down vote accepted

Looks like Excel is interpreting that as a formula. Try prepending an apostrophe, to force Excel to treat it as plain text:

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .