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.

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.

2 Answers 2

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:

01,022,100,04  

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)

'01,'022,'100,'04  

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:

"01","022","100","04"  
-or-  
"'01","'022","'100","'04"  
share|improve this answer

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

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