Open .csv file drops leading zeros even with quote delimited?

[cboshdave]

First, I have read through the import postings. I know this has been discussed, but I cannot seem to find the specific answer to what I am looking for.
The question that I still have is if I create a .csv file programatically for a non-excel user and I save the values as:
"01234","Person1"
"12345","Person2"

When I open the .csv file with Excel, why would Excel drop the leading zeros? I thought that would make it clearer to excel to treat it differently?? My users have to open this file all the time. I need to make it easier to open and deal with rather than having an import every time. Additionally, I need to read the file back in with their changes. So, I don't want a bunch of extraneous data. There was one suggestion that I create the file like (I think):
"01234","Person1","""A1"""
"12345","Person2","""A2"""
and that would preserve the leading 0. But I don't really want to handle the quotes when I read the file back in (extraneous data).

I know I am being picky, but there has to be a way around this that is not such a pain! I am trying to keep this process simple for my users and I am stumped.

Thanks,
Dave

 

[martindwilson]

it wont when opened in notepad,or another text editor its just that you have excel set to open csv,and excel does what it wants to do