How do I input zeroes in a zip code for a mail merge?

Couple ways:

1) Format the cell as Text: Format->Cells->Text
2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
'00345
3) Enter the zip code with the formula ="00345"

Number 1 will probably be most usefull to you.
--
Regards,
db


"S_Suarez" wrote:

> I am trying to do a mail merge for a mass mailing I need to do. I am trying
> to input zeros in the zip codes that start with zero. When I type in the
> zero, Excel automatically erases it. How can I input a zero without having
> excel automatically erase it?

Suarez,

Change the format of the cell. Select the cells into which you are
inputting your zip codes, Then click Format...Cells...Number. Click on
"Custom" in the list and in the "Type:" field, enter 00000.

Knightly

S_Suarez Wrote:
> I am trying to do a mail merge for a mass mailing I need to do. I am
> trying
> to input zeros in the zip codes that start with zero. When I type in
> the
> zero, Excel automatically erases it. How can I input a zero without
> having
> excel automatically erase it?


--
sirknightly

Thanks so much! Your post was very helpful!

"db" wrote:

> Couple ways:
>
> 1) Format the cell as Text: Format->Cells->Text
> 2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
> '00345
> 3) Enter the zip code with the formula ="00345"
>
> Number 1 will probably be most usefull to you.
> --
> Regards,
> db
>
>
> "S_Suarez" wrote:
>
> > I am trying to do a mail merge for a mass mailing I need to do. I am trying
> > to input zeros in the zip codes that start with zero. When I type in the
> > zero, Excel automatically erases it. How can I input a zero without having
> > excel automatically erase it?

Format the cells as Text first

Format->Cells->Number tab, then select Text

"S_Suarez" wrote:

> I am trying to do a mail merge for a mass mailing I need to do. I am trying
> to input zeros in the zip codes that start with zero. When I type in the
> zero, Excel automatically erases it. How can I input a zero without having
> excel automatically erase it?

Thank you so much for your help!

"Duke Carey" wrote:

> Format the cells as Text first
>
> Format->Cells->Number tab, then select Text
>
> "S_Suarez" wrote:
>
> > I am trying to do a mail merge for a mass mailing I need to do. I am trying
> > to input zeros in the zip codes that start with zero. When I type in the
> > zero, Excel automatically erases it. How can I input a zero without having
> > excel automatically erase it?

Thank you so much for your help!

"Duke Carey" wrote:

> Format the cells as Text first
>
> Format->Cells->Number tab, then select Text
>
> "S_Suarez" wrote:
>
> > I am trying to do a mail merge for a mass mailing I need to do. I am trying
> > to input zeros in the zip codes that start with zero. When I type in the
> > zero, Excel automatically erases it. How can I input a zero without having
> > excel automatically erase it?

Suarez,

Change the format of the cell. Select the cells into which you are
inputting your zip codes, Then click Format...Cells...Number. Click on
"Custom" in the list and in the "Type:" field, enter 00000.

Knightly

S_Suarez Wrote:
> I am trying to do a mail merge for a mass mailing I need to do. I am
> trying
> to input zeros in the zip codes that start with zero. When I type in
> the
> zero, Excel automatically erases it. How can I input a zero without
> having
> excel automatically erase it?


--
sirknightly

Thanks so much! Your post was very helpful!

"db" wrote:

> Couple ways:
>
> 1) Format the cell as Text: Format->Cells->Text
> 2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
> '00345
> 3) Enter the zip code with the formula ="00345"
>
> Number 1 will probably be most usefull to you.
> --
> Regards,
> db
>
>
> "S_Suarez" wrote:
>
> > I am trying to do a mail merge for a mass mailing I need to do. I am trying
> > to input zeros in the zip codes that start with zero. When I type in the
> > zero, Excel automatically erases it. How can I input a zero without having
> > excel automatically erase it?

Format the cells as Text first

Format->Cells->Number tab, then select Text

"S_Suarez" wrote:

> I am trying to do a mail merge for a mass mailing I need to do. I am trying
> to input zeros in the zip codes that start with zero. When I type in the
> zero, Excel automatically erases it. How can I input a zero without having
> excel automatically erase it?

Couple ways:

1) Format the cell as Text: Format->Cells->Text
2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
'00345
3) Enter the zip code with the formula ="00345"

Number 1 will probably be most usefull to you.
--
Regards,
db


"S_Suarez" wrote:

> I am trying to do a mail merge for a mass mailing I need to do. I am trying
> to input zeros in the zip codes that start with zero. When I type in the
> zero, Excel automatically erases it. How can I input a zero without having
> excel automatically erase it?

Suarez,

Change the format of the cell. Select the cells into which you are
inputting your zip codes, Then click Format...Cells...Number. Click on
"Custom" in the list and in the "Type:" field, enter 00000.

Knightly

S_Suarez Wrote:
> I am trying to do a mail merge for a mass mailing I need to do. I am
> trying
> to input zeros in the zip codes that start with zero. When I type in
> the
> zero, Excel automatically erases it. How can I input a zero without
> having
> excel automatically erase it?


--
sirknightly

Suarez,

Change the format of the cell. Select the cells into which you are
inputting your zip codes, Then click Format...Cells...Number. Click on
"Custom" in the list and in the "Type:" field, enter 00000.

Knightly

S_Suarez Wrote:
> I am trying to do a mail merge for a mass mailing I need to do. I am
> trying
> to input zeros in the zip codes that start with zero. When I type in
> the
> zero, Excel automatically erases it. How can I input a zero without
> having
> excel automatically erase it?


--
sirknightly

Thank you so much for your help!

"Duke Carey" wrote:

> Format the cells as Text first
>
> Format->Cells->Number tab, then select Text
>
> "S_Suarez" wrote:
>
> > I am trying to do a mail merge for a mass mailing I need to do. I am trying
> > to input zeros in the zip codes that start with zero. When I type in the
> > zero, Excel automatically erases it. How can I input a zero without having
> > excel automatically erase it?

I am trying to do a mail merge for a mass mailing I need to do. I am trying
to input zeros in the zip codes that start with zero. When I type in the
zero, Excel automatically erases it. How can I input a zero without having
excel automatically erase it?

Thanks so much! Your post was very helpful!

"db" wrote:

> Couple ways:
>
> 1) Format the cell as Text: Format->Cells->Text
> 2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
> '00345
> 3) Enter the zip code with the formula ="00345"
>
> Number 1 will probably be most usefull to you.
> --
> Regards,
> db
>
>
> "S_Suarez" wrote:
>
> > I am trying to do a mail merge for a mass mailing I need to do. I am trying
> > to input zeros in the zip codes that start with zero. When I type in the
> > zero, Excel automatically erases it. How can I input a zero without having
> > excel automatically erase it?

Format the cells as Text first

Format->Cells->Number tab, then select Text

"S_Suarez" wrote:

> I am trying to do a mail merge for a mass mailing I need to do. I am trying
> to input zeros in the zip codes that start with zero. When I type in the
> zero, Excel automatically erases it. How can I input a zero without having
> excel automatically erase it?

Couple ways:

1) Format the cell as Text: Format->Cells->Text
2) Enter the zip code with a ' preceding the number, i.e. enter 00345 as
'00345
3) Enter the zip code with the formula ="00345"

Number 1 will probably be most usefull to you.
--
Regards,
db


"S_Suarez" wrote:

> I am trying to do a mail merge for a mass mailing I need to do. I am trying
> to input zeros in the zip codes that start with zero. When I type in the
> zero, Excel automatically erases it. How can I input a zero without having
> excel automatically erase it?

Suarez,

Change the format of the cell. Select the cells into which you are
inputting your zip codes, Then click Format...Cells...Number. Click on
"Custom" in the list and in the "Type:" field, enter 00000.

Knightly

S_Suarez Wrote:
> I am trying to do a mail merge for a mass mailing I need to do. I am
> trying
> to input zeros in the zip codes that start with zero. When I type in
> the
> zero, Excel automatically erases it. How can I input a zero without
> having
> excel automatically erase it?


--
sirknightly