Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I've used Excel more than I care to think about, but this is a new one for me. I have a cell with a simple formula, =Counts!E3. I set the number format to General. I edit the cell (just F2-Enter, no change). The formula no longer works, and when I check the number format, it's now Text.

Has anyone else seen this behavior? Maybe found a fix? I can change the format to General and hope no one touches it (or set up worksheet protection), but if there's a hotfix or something that would be groovytacular.

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

You need to set the format to Number.

General means Excel is going to guess, and thus change the format on its own. This is usually more apparent when you enter in Dates/Time. Best that you go ahead and explicitly change it if this happens again.

share|improve this answer
    
Very strange. I realize that General allows Excel to use a variety of formats based on its guess as to what the data is, but I've not seen it actually change the cell's type before. Also odd, changing the type from General to a custom type was not good enough: it still changed it to Text. But setting it to Number worked. Fortunately, I'm not using this cell to display anything, so I don't actually care what format Excel uses... this time. –  Jon of All Trades Jan 25 '12 at 22:18
    
I see this all the time when a CSV is imported. By default, it is imported as General. –  surfasb Jan 26 '12 at 1:21
add comment

I had same / similar problem with excel. Even if I changed the format of the cell to either General or Number. If I entered the formula after formatting the cell everything was fine, however, if I made a change to the formula the cell format automatically changed to Text. On closer examination I discovered that other cells referenced by the formula even though were displaying numbers were actually formatted as text, therefore, excel changed the cell containing the formula to text.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.