Home » Category » Microsoft Excel

Microsoft Excel: zip codes without losing leading zero from csv

205| Thu, 22 May 2008 08:19:00 GMT| anonymous| Comments (5)
I create text files (csv) from Informix 4gl and I often need to send
zipcodes. When csv files open in excel, you lose the leading 0 for states
like CT, NJ, and MA. Is there an ascii character to put in front of zip? I
can't depend on users to change the formatting of the cells.

Keywords & Tags: zip, codes, losing, leading, zero, csv, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495125/
 
«« Prev - Next »» 5 helpful answers below.
Maybe you could change your CSV generator to create data like:
="01234"

mccafl wrote:
> I create text files (csv) from Informix 4gl and I often need to send
> zipcodes. When csv files open in excel, you lose the leading 0 for states
> like CT, NJ, and MA. Is there an ascii character to put in front of zip? I
> can't depend on users to change the formatting of the cells.
--

Dave Peterson

dave | Thu, 22 May 2008 08:20:00 GMT |

On Feb 28, 4:57 pm, mccafl <mcc......discussions.microsoft.com> wrote:
> I create text files (csv) from Informix 4gl and I often need to send
> zipcodes. When csv files open in excel, you lose the leading 0 for states
> like CT, NJ, and MA. Is there an ascii character to put in front of zip? I
> can't depend on users to change the formatting of the cells.

What would happen if you made the zip codes as text not as numbers?

stan | Thu, 22 May 2008 08:21:00 GMT |

How do I get excel to know that is it text without have the quotes show?

"Stan" wrote:

> On Feb 28, 4:57 pm, mccafl <mcc......discussions.microsoft.com> wrote:
> > I create text files (csv) from Informix 4gl and I often need to send
> > zipcodes. When csv files open in excel, you lose the leading 0 for states
> > like CT, NJ, and MA. Is there an ascii character to put in front of zip? I
> > can't depend on users to change the formatting of the cells.
> What would happen if you made the zip codes as text not as numbers?
>

mccafl | Thu, 22 May 2008 08:22:00 GMT |

Stan,

If you see the zeroes on the sheet before you write the file as csv, it's probably including
them in the file. Open it with NotePad to see for sure.
--
Earl Kiosterud
www.smokeylake.com
----
"mccafl" <mccafl...discussions.microsoft.com> wrote in message
news:C54CD97A-AC26-4EC1-B42F-37CA2E082E60...microsoft.com...
> How do I get excel to know that is it text without have the quotes show?
> "Stan" wrote:
>> On Feb 28, 4:57 pm, mccafl <mcc......discussions.microsoft.com> wrote:
>> > I create text files (csv) from Informix 4gl and I often need to send
>> > zipcodes. When csv files open in excel, you lose the leading 0 for states
>> > like CT, NJ, and MA. Is there an ascii character to put in front of zip? I
>> > can't depend on users to change the formatting of the cells.
>> What would happen if you made the zip codes as text not as numbers?
>>

earl | Thu, 22 May 2008 08:23:00 GMT |

Rename the CSV file as .txt, and then Excel's text import wizard allows you
to specify the column as text.
--
David Biddulph

"mccafl" <mccafl...discussions.microsoft.com> wrote in message
news:C54CD97A-AC26-4EC1-B42F-37CA2E082E60...microsoft.com...
> How do I get excel to know that is it text without have the quotes show?
> "Stan" wrote:
>> On Feb 28, 4:57 pm, mccafl <mcc......discussions.microsoft.com> wrote:
>> > I create text files (csv) from Informix 4gl and I often need to send
>> > zipcodes. When csv files open in excel, you lose the leading 0 for
>> > states
>> > like CT, NJ, and MA. Is there an ascii character to put in front of
>> > zip? I
>> > can't depend on users to change the formatting of the cells.
>> What would happen if you made the zip codes as text not as numbers?
>>

david | Thu, 22 May 2008 08:24:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories