Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Tom4200 Tom4200 is offline
external usenet poster
 
Posts: 1
Default mail merge figures starting w/ zero

Is there a way to mail merge an excel field that starts with a zero to my
word document ? Using Office 2007
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default mail merge figures starting w/ zero

If the value is coming across as a number, then the best you can do is
use a numeric format to ensure a fixed number of digits.

e.g. use alt-F9 to view yur field code, which will look somethin glike

{ MERGEFIELD myfield }

(Delete any other stuff after "myfield")

Then, if all your numbers should have, say, 5 digits, use

{ MERGEFIELD myfield \#00000 }

(so a number that comes across as 123 would display as 00123)

If you need to preserve the exact text you have in Excel, and that text
has a variable number of digits, post back.


Peter Jamieson

http://tips.pjmsn.me.uk

On 18/05/2010 14:00, Tom4200 wrote:
Is there a way to mail merge an excel field that starts with a zero to my
word document ? Using Office 2007

  #3   Report Post  
johngill johngill is offline
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by Tom4200 View Post
Is there a way to mail merge an excel field that starts with a zero to my
word document ? Using Office 2007
Well sorry but not have much more information about it....
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't mail merge a zip code starting with a zero (02657) Dennis[_4_] Microsoft Word Help 1 February 22nd 08 05:15 AM
HOW DO YOU CHANGE THE STARTING LABEL IN A MAIL MERGE? anjjohnson Mailmerge 1 October 7th 06 07:29 PM
How to do a mail merge with a text box in starting document? Emily Mailmerge 1 August 8th 06 04:35 AM
Zip codes starting with 0 in Mail Merge chris76 Mailmerge 1 May 18th 06 06:41 PM
How to remove mail merge from a new starting document? Aideesg New Users 1 September 10th 05 06:53 AM


All times are GMT +1. The time now is 12:33 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"