[PrintOwners] Excel Zip Code help

[Simon Sheers]

Hope this helps.

> I know this can be done, but haven't done it enough. I have an Excel  
> file
> and one of the zip codes is for New Jersey. It starts with a 0. It is
> dropping it. I know why, but I don't know how to fix.

 From my archives:

Select the column you are using, and hit format cells.  Under the  
type, select general, and then you can type in four zeros or whatever  
amount you need. (0000).  That will make the cells numbers with zeros  
in front of them.  Then you can type in the start number in the top of  
the column, and hit Edit > Fill > Series and you can make the numbers  
increase by 1 and put in the stop number.

That all works great.  But. . . when I merge the numbers in InDesign  
it always starts with 0002  and goes forward, instead of starting with  
0001.  I assume that's because it assumes line one is the title of the  
file, but I can't find any way to put a title in line 1 and still get  
it to put numbers in line 2 and on.  If I put a title in line 1 it  
just copies that title down the column.
What am I doing wrong now?
Do you have to manually type in a title in the.csv file? or what?

After I get my columns set up for whatever job I'm doing, I go in and  
add a new row, and then put labels in the top.  For instance, on a  
three up item I'll have three rows of numbers, and label them top,  
middle, and bottom.  Or 1, 2 and 3, or whatever.  The numbers come out  
right then.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michelle Maynor
-----------------------------------------------------------

Select the cells where you want leading zeros to appear...

Format ---> Cells ---> Number Tab ---> Custom

In the box in the right hand column of the dialog box
under "Type", enter the number of zeros corresponding to
the total number of digits you want in your printed number.

For example, if you want 4 digit numbers, like 0001,
enter four zeros in the box.

That takes care of it.

Doug Shelton
--------------------------------------------------------------



Please reply to Simon Sheers at:
<ssheers at sheergraphics.com>

Sheer Graphics Inc.
47 Chestnut Avenue,
Westmont, IL 60559-1127
Tel: (630) 654-4422
<http://www.sheergraphics.com>
Printing the message . . . and a whole lot more