software

I've formatted the column as well as tried formatting just an individual cell
for Postal Code. It always drops the first number if it is a zero. I've
formatted the cell as text wtih an apostrophe and was able to retain the
zero. However, I have to remember to do this for every Postal Code that
begins with zero and it's incredibly inefficient process. I don't always
remember to do that and then when I merge my document and Postal Codes
beginning with a zero come over without the beginning zero! This document is
an an address database so I continually run into this problem. I've done
everything I can think of, and wasted alot of time trying to figure this out.
Can someone please assist me? Thank you!

If you format the whole column as TEXT, then you do not need the leading
apostrophe's and the leading zero will be retained.

Vaya con Dios,
Chuck, CABGx3
quot;Laureenquot; wrote:

gt; I've formatted the column as well as tried formatting just an individual cell
gt; for Postal Code. It always drops the first number if it is a zero. I've
gt; formatted the cell as text wtih an apostrophe and was able to retain the
gt; zero. However, I have to remember to do this for every Postal Code that
gt; begins with zero and it's incredibly inefficient process. I don't always
gt; remember to do that and then when I merge my document and Postal Codes
gt; beginning with a zero come over without the beginning zero! This document is
gt; an an address database so I continually run into this problem. I've done
gt; everything I can think of, and wasted alot of time trying to figure this out.
gt; Can someone please assist me? Thank you!


Maybe I'm not understanding, but I formatted the cell using the special
category, zip code type. I entered a 5 digit code with the first # a
zero. The cell shows the whole number including the zero.
Lisa--
vencopbrass
------------------------------------------------------------------------
vencopbrass's Profile: www.excelforum.com/member.php...oamp;userid=31868
View this thread: www.excelforum.com/showthread...hreadid=517369Select the colums where the zip codes are going to be entered and click
FORMAT in the menu and select CELLS. If necessary click the NUMBER tab. In
the CATEGORY list, select SPECIAL, and in the TYPE panel select Zip Code or
Zip Code 4
--
Kevin Backmannquot;Laureenquot; wrote:

gt; I've formatted the column as well as tried formatting just an individual cell
gt; for Postal Code. It always drops the first number if it is a zero. I've
gt; formatted the cell as text wtih an apostrophe and was able to retain the
gt; zero. However, I have to remember to do this for every Postal Code that
gt; begins with zero and it's incredibly inefficient process. I don't always
gt; remember to do that and then when I merge my document and Postal Codes
gt; beginning with a zero come over without the beginning zero! This document is
gt; an an address database so I continually run into this problem. I've done
gt; everything I can think of, and wasted alot of time trying to figure this out.
gt; Can someone please assist me? Thank you!

use a custom format of

00000quot;Laureenquot; wrote:

gt; I've formatted the column as well as tried formatting just an individual cell
gt; for Postal Code. It always drops the first number if it is a zero. I've
gt; formatted the cell as text wtih an apostrophe and was able to retain the
gt; zero. However, I have to remember to do this for every Postal Code that
gt; begins with zero and it's incredibly inefficient process. I don't always
gt; remember to do that and then when I merge my document and Postal Codes
gt; beginning with a zero come over without the beginning zero! This document is
gt; an an address database so I continually run into this problem. I've done
gt; everything I can think of, and wasted alot of time trying to figure this out.
gt; Can someone please assist me? Thank you!


quot;Laureenquot; gt; wrote in message
...
gt; I've formatted the column as well as tried formatting just an individual
gt; cell
gt; for Postal Code. It always drops the first number if it is a zero. I've
gt; formatted the cell as text wtih an apostrophe and was able to retain the
gt; zero. However, I have to remember to do this for every Postal Code that
gt; begins with zero and it's incredibly inefficient process. I don't always
gt; remember to do that and then when I merge my document and Postal Codes
gt; beginning with a zero come over without the beginning zero! This document
gt; is
gt; an an address database so I continually run into this problem. I've done
gt; everything I can think of, and wasted alot of time trying to figure this
gt; out.
gt; Can someone please assist me? Thank you!

Format the cells as text BEFORE entering or copying data into them. Do it
for enough empty cells to take care of future needs.
Thanks everyone! Chuck's suggestion worked best forme. I've previously
tried all of your other suggestions and for some odd reason, it still kept
dropping the zero! Crazy, huh?!
Although when I formatted the column as Chuck suggested, I did have to go
back and re-enter a zero to all the Postal Codes I previously entered. The
foolish thing dropped them all!
Anyway, I'm all set now and I thank you!
Muchos Gracias Chuck!

quot;CLRquot; wrote:

gt; If you format the whole column as TEXT, then you do not need the leading
gt; apostrophe's and the leading zero will be retained.
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Laureenquot; wrote:
gt;
gt; gt; I've formatted the column as well as tried formatting just an individual cell
gt; gt; for Postal Code. It always drops the first number if it is a zero. I've
gt; gt; formatted the cell as text wtih an apostrophe and was able to retain the
gt; gt; zero. However, I have to remember to do this for every Postal Code that
gt; gt; begins with zero and it's incredibly inefficient process. I don't always
gt; gt; remember to do that and then when I merge my document and Postal Codes
gt; gt; beginning with a zero come over without the beginning zero! This document is
gt; gt; an an address database so I continually run into this problem. I've done
gt; gt; everything I can think of, and wasted alot of time trying to figure this out.
gt; gt; Can someone please assist me? Thank you!

You're more than welcome, and thanks for the feedback.........

Vaya con Dios,
Chuck, CABGx3
quot;Laureenquot; wrote:

gt; Thanks everyone! Chuck's suggestion worked best forme. I've previously
gt; tried all of your other suggestions and for some odd reason, it still kept
gt; dropping the zero! Crazy, huh?!
gt; Although when I formatted the column as Chuck suggested, I did have to go
gt; back and re-enter a zero to all the Postal Codes I previously entered. The
gt; foolish thing dropped them all!
gt; Anyway, I'm all set now and I thank you!
gt; Muchos Gracias Chuck!
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; If you format the whole column as TEXT, then you do not need the leading
gt; gt; apostrophe's and the leading zero will be retained.
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Laureenquot; wrote:
gt; gt;
gt; gt; gt; I've formatted the column as well as tried formatting just an individual cell
gt; gt; gt; for Postal Code. It always drops the first number if it is a zero. I've
gt; gt; gt; formatted the cell as text wtih an apostrophe and was able to retain the
gt; gt; gt; zero. However, I have to remember to do this for every Postal Code that
gt; gt; gt; begins with zero and it's incredibly inefficient process. I don't always
gt; gt; gt; remember to do that and then when I merge my document and Postal Codes
gt; gt; gt; beginning with a zero come over without the beginning zero! This document is
gt; gt; gt; an an address database so I continually run into this problem. I've done
gt; gt; gt; everything I can think of, and wasted alot of time trying to figure this out.
gt; gt; gt; Can someone please assist me? Thank you!