Charting table data beginning with zero

[Marilyn]

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

 

[Jon Peltier]

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/
_______

 

[Spike9458]

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

--Jim

 

[Jon Peltier]

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/
_______