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 have a column of hexadecimal strings:


I need excel to store these as strings, not integers or floats.

share|improve this question
up vote 18 down vote accepted

All you need to do for this one is put a single quote in front of your text. This also works for dates you don't want Excel picking up.



You can also format your entire column as text which will override the whole column. In Excel 2007, hilight your cells, Right click->Format Cells. Click on text from the options on the left.

share|improve this answer

User dubRun made two solutions. The one with putting ' on the beginning is much better solution that setting the cells as TEXT in FORMAT CELLS option.

Setting cells as TEXT in FORMAT CELLS is somewhat very stubborn option. You put it as TEXT, enter some number in cells and it automatically reverses it into number again.

So just enter ' in one cell, drag it through whole column/row, and the problem is solved.

Regards, Vilim.

share|improve this answer
Are you providing an answer to the question?  It seems like you’re primarily expressing approval for one previous answer, and disapproval for another.  That’s OK, but it should be done in a comment, not in an answer.  You can always comment on your own posts, and once you have sufficient reputation you will be able to comment on any post.  … (Cont’d) – Scott Oct 19 '15 at 8:01
(Cont’d) … If you’re adding information to a previous answer, that’s good — but I don’t understand what you’re saying.  “So just enter ' in one cell [and] drag it through whole column/row …”  If you do that first, and then enter your data, the quote characters are overwritten (i.e., lost).  But if you enter your data first, and then enter the quotes, the data are lost.  How do you think you can make this work? – Scott Oct 19 '15 at 8:01

You must log in to answer this question.

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