<p>I want to generate a CSV file for user to use Excel to open it.</p>

<p>If I want to escape the comma in values, I can write it as "640,480".</p>

<p>If I want to keep the leading zeros, I can use ="001234".</p>

<p>But if I want to keep both comma and leading zeros in the value, writing as ="001,002" will be splitted as two columns.  It seems no solution to express the correct data.</p>

<p>Is there any way to express <strong>001, 002</strong> in CSV for Excel?</p>

Do
```
```
"""001,002"""
```
```
I found this out by typing "001,002" and then doing save-as CSV in Excel. If this isn't exactly what you want (you don't want quotes), this might be a good way for you to find what you want.
Another option might be use tab-delimited text, if this is an option for you.