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


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

share|improve this question

1 Answer 1

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

Your Answer


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.