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

Possible Duplicate:
Adding a zero before values in an Excel spreadsheet column?

I'm trying to start a number with zero in Excel's CSV format, but I'm not able to do that.

share|improve this question

marked as duplicate by slhck Nov 11 '12 at 13:14

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Because you are doing this with excel, you have to format this column or cell where you want to have leading zeros as text-format or with a custom format like "0000.00".

Another way would be entering your values like this '001005

share|improve this answer

You should edit your question to provide an example of how your CSV file might look.

I think you mean your CSV file looks something like this:


and you want Excel to show this:

[  01][  022][  100][  04]  

but Excel displays this as:

[  1][  22][  100][  4]  

If this describes your problem, then try adding a single-quote-mark (apostrophe) before the number in your CSV file to indicate text rather than numeric like this: (as suggested by Jook)


which should work, but this could very much depend on your version of Excel.

If that doesn't work, try using double quotes like this:

share|improve this answer

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