Charting table data beginning with zero

  • Thread starter Thread starter Marilyn
  • Start date Start date
M

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
 
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/
_______
 
What happens when using Excel, you select the zipcode column, and go to
Format/Cells/Special/Zipcode?

--Jim
 
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/
_______
 
Back
Top