I have a large mailling list table in Word. I am trying
to convert it to Access, but have had trouble with
importing the data - a lot is corrupted in the
translation. A friend suggested pasting it into Excel
first and then converting. This seems to work very well
except for the Postal Code column. When the postal codes
begin with zero, Excel is dropping the zero in the
pasting operation and will not accept it even if I
manually record it. I tried going into
tools>options>error checking>text to numbers (both on and
off) but this doesn't seem to help. Any help is
tremendously appreciated. Thanks in advance

Type an apostrophe first, like '01234. This tells Excel to treat the
cell contents as text.

You could also use a custom number format of 00000 (five zeros), and the
value within the cell would retain its numerical character. But I
suspect this might not survive the export.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Marilyn wrote:

> I have a large mailling list table in Word. I am trying
> to convert it to Access, but have had trouble with
> importing the data - a lot is corrupted in the
> translation. A friend suggested pasting it into Excel
> first and then converting. This seems to work very well
> except for the Postal Code column. When the postal codes
> begin with zero, Excel is dropping the zero in the
> pasting operation and will not accept it even if I
> manually record it. I tried going into
> tools>options>error checking>text to numbers (both on and
> off) but this doesn't seem to help. Any help is
> tremendously appreciated. Thanks in advance

What happens when using Excel, you select the zipcode column, and go to
Format/Cells/Special/Zipcode?

--Jim

"Jon Peltier" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Type an apostrophe first, like '01234. This tells Excel to treat the
> cell contents as text.
>
> You could also use a custom number format of 00000 (five zeros), and the
> value within the cell would retain its numerical character. But I
> suspect this might not survive the export.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Marilyn wrote:
>
> > I have a large mailling list table in Word. I am trying
> > to convert it to Access, but have had trouble with
> > importing the data - a lot is corrupted in the
> > translation. A friend suggested pasting it into Excel
> > first and then converting. This seems to work very well
> > except for the Postal Code column. When the postal codes
> > begin with zero, Excel is dropping the zero in the
> > pasting operation and will not accept it even if I
> > manually record it. I tried going into
> > tools>options>error checking>text to numbers (both on and
> > off) but this doesn't seem to help. Any help is
> > tremendously appreciated. Thanks in advance
>

I forgot about those special formats. I wonder if they survive the trip
to Access.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Spike9458 wrote:
> What happens when using Excel, you select the zipcode column, and go to
> Format/Cells/Special/Zipcode?
>
> --Jim
>
> "Jon Peltier" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>>Type an apostrophe first, like '01234. This tells Excel to treat the
>>cell contents as text.
>>
>>You could also use a custom number format of 00000 (five zeros), and the
>>value within the cell would retain its numerical character. But I
>>suspect this might not survive the export.
>>
>>- Jon
>>-------
>>Jon Peltier, Microsoft Excel MVP
>>Peltier Technical Services
>>Tutorials and Custom Solutions
>>http://PeltierTech.com/
>>_______
>>
>>Marilyn wrote:
>>
>>
>>>I have a large mailling list table in Word. I am trying
>>>to convert it to Access, but have had trouble with
>>>importing the data - a lot is corrupted in the
>>>translation. A friend suggested pasting it into Excel
>>>first and then converting. This seems to work very well
>>>except for the Postal Code column. When the postal codes
>>>begin with zero, Excel is dropping the zero in the
>>>pasting operation and will not accept it even if I
>>>manually record it. I tried going into
>>>tools>options>error checking>text to numbers (both on and
>>>off) but this doesn't seem to help. Any help is
>>>tremendously appreciated. Thanks in advance
>>
>
>