|
|
|
|
|
Forum
-> Computers, Phones and Devices
im here!
|
Thu, Feb 18 2010, 12:56 pm
I printed out invitation labels, but for some reason all NJ labels printed without the zipcode.
What can I do it should appear on the labels?
Last edited by im here! on Thu, Feb 18 2010, 2:55 pm; edited 1 time in total
| |
|
Back to top |
0
0
|
chocolate moose
|
Thu, Feb 18 2010, 2:04 pm
what program are you using ?
| |
|
Back to top |
0
0
|
im here!
|
Thu, Feb 18 2010, 2:08 pm
I typed the list in microsoft excel & printed from microsoft word (mail merge)
| |
|
Back to top |
0
0
|
Kumphort
|
Thu, Feb 18 2010, 2:59 pm
probably because NJ begins with a "0", go back in excel, highlight the column and make it a text column
| |
|
Back to top |
0
0
|
im here!
|
Mon, Feb 22 2010, 1:07 am
Kumphort wrote: | probably because NJ begins with a "0", go back in excel, highlight the column and make it a text column |
I tried doing that it didnt work, any other options?
Unless if I didnt do the right thing. How do I change it to text?
| |
|
Back to top |
0
0
|
newwife14
|
Mon, Feb 22 2010, 8:21 am
After you change the format of the column to text, you have to actually double click in each cell or it won't change. If you change the formatting to text before typing then you wouldn't have to do this.
| |
|
Back to top |
0
0
|
MamaChips
|
Mon, Dec 13 2010, 11:23 pm
Go into Excel and put an apostrophe before the 0. For example, it would read
Englewood, New Jersey '07631
Do this before each zip code beginning with 0. The apostrophe will NOT show up in Word.
| |
|
Back to top |
0
0
|
Related Topics |
Replies |
Last Post |
|
|
Name labels
|
1 |
Thu, May 09 2024, 9:41 am |
|
|
I have a spending problem
|
3 |
Mon, May 06 2024, 1:43 pm |
|
|
Yeast problem
|
2 |
Fri, May 03 2024, 7:27 pm |
|
|
The real problem
|
98 |
Thu, Apr 04 2024, 4:33 pm |
|
|
First world problem
|
9 |
Thu, Mar 14 2024, 7:43 pm |
|
|
Imamother may earn commission when you use our links to make a purchase.
© 2024 Imamother.com - All rights reserved
| |
|
|
|
|
|