#1   Report Post  
Old April 5th 05, 04:07 AM
mphope
 
Posts: n/a
Default zip code entry

I saw a couple of other posts regarding the problem with the zeros not
displaying properly in zip code entries. I'm able to see the zeros, but when
i try to mail merge the zeros are there but the rest of the zip code
dissapears. Or if I don't format the cell as text, then the zeros don't
print, only the last four digits print. So i either get 0 by itself, or 1234
with no zero in front. Can someone please help me?

  #2   Report Post  
Old April 5th 05, 01:11 PM
Dave Peterson
 
Posts: n/a
Default

Debra Dalgleish posted this for a different question:

In the Mail Merge, after you select your Excel file as a data source,
you should see a 'Confirm Data Source' dialog box.
(If you don't see the dialog box, change the setting in Word --
under ToolsOptions, General -- add a check mark to
'Confirm Conversion at Open')

From that list, choose 'MS Excel Worksheets via DDE (*.xls)', and your
formatting will be retained.

If you have to connect through a different source, you can format the
fields in the Word document. For example, to specify a number of decimals:

1. In Word, in the Main Document, press Alt+F9 to view the field codes.
2. Find the field code for the number. It will look something like:
{ MERGEFIELD FieldName }
3. Add a switch, to format the number with two decimal places.
For example:
{ MERGEFIELD FieldName \# "#,##0.00" }
4. Press Alt+F9 to hide the field codes.
5. Save the Main Document

You'll have to change the format to what you need.

==========
An alternative.

Use a helper cell with a fromula like:
=text(a1,"00000")
and use that in your mailmerge.

mphope wrote:

I saw a couple of other posts regarding the problem with the zeros not
displaying properly in zip code entries. I'm able to see the zeros, but when
i try to mail merge the zeros are there but the rest of the zip code
dissapears. Or if I don't format the cell as text, then the zeros don't
print, only the last four digits print. So i either get 0 by itself, or 1234
with no zero in front. Can someone please help me?


--

Dave Peterson


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
zip code entry Margo Excel Worksheet Functions 0 April 5th 05 04:07 AM
Make Change Case in Excel a format rather than formula Kevin Excel Worksheet Functions 1 March 18th 05 08:53 PM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 4th 05 10:50 AM
Opening a file with code without a set file name jenkinspat Excel Discussion (Misc queries) 1 March 3rd 05 03:40 PM
Error trapped only while stepping through the code - Not triggered when run Jeff Excel Discussion (Misc queries) 0 February 28th 05 06:26 PM


All times are GMT +1. The time now is 05:02 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017