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:

506078
363624
505974
505644

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

share|improve this question

1 Answer 1

up vote 17 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.

eg.

'23446

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

 
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.