Reply
 
Thread Tools Display Modes
  #1   Report Post  
shsnan08 shsnan08 is offline
Junior Member
 
Posts: 1
Default Formatting a field from a source with numbers and a sometimes a letter

Hi
In my excel-sheet (source document) I have a column with ssnr in looking like "########-####" and some with "########-T###". The format in the column in excel is Custom "########-####".

How can I merge this numbers in to my word document?
Right now I have "{MERGEFIELD ssnr \# ########'-'####}"
When I merge and the source document contains a T the result in my word document is just "-".
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
Formatting a merge field that contains both text and numbers Drew Mailmerge 4 February 3rd 10 08:47 AM
Missing date field in file select field (get data source) Leslie Gottlieb Mailmerge 2 August 24th 09 11:18 PM
Paste Special, Keep Source Formatting: source still changes DonD Microsoft Word Help 1 June 6th 06 07:12 PM
Sole Source Letter Template blah, blah, blah Microsoft Word Help 1 April 18th 06 09:07 PM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM


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

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

About Us

"It's about Microsoft Word"