Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not printing 0 in zipcodes from excel spreadsheet.
When I merge into labels in word it is not printing the 0 of the zipcodes
that start with a 0. I have tried putting a ' in front of it. Thanks, Christy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not printing 0 in zipcodes from excel spreadsheet.
Did you put the apostrophe in the data in excel?
'01234 I've don't think I've seen that fail with mailmerge. But.... Debra Dalgleish posted this to a similar question: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. iamdevoe wrote: When I merge into labels in word it is not printing the 0 of the zipcodes that start with a 0. I have tried putting a ' in front of it. Thanks, Christy -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Hyperlinking to Excel 2000 with a linked spreadsheet | Excel Discussion (Misc queries) | |||
can you use cell references from Microsoft spreadsheet in excel ch | Excel Worksheet Functions | |||
Send Excel 2002 spreadsheet to MacIntosh Excel 2004 | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |