Leading zeroes

[David Hamacher]

How do I keep the leading zeroes in the zip codes of databases that I save in ascii text?
Formatting them as text or zip codes or general doesn't do it.

 

[codyswan]

How about a leading space? Almost any text character will do. The nice thing about a leading space is that it doesn't get in your way if you are printing the data or using it for mail merge.

You can also just turn it into text instead of a number using the text function. It still sorts properly. As text, Excel will want to left align instead of right align.

 

[Mark W.]

On 2002-03-28 10:56, David Hamacher wrote:
How do I keep the leading zeroes in the zip codes of databases that I save in ascii text?
Formatting them as text or zip codes or general doesn't do it.

Why have you concluded that the Zipcode formatting doesn't preserve the leading zeroes when saving as a Tab-delimited text file (.txt)? It works for me!

 

[Ian Mac]

try custom format 00000

 

[tweetyksc]

format the cell with a custom format.
i.e. 00000