| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
merging data from Excel with data having digit "0" infront
hi community
when I merged data from excel e.g: 055111 as Postal Code using Mail Merge feature, the front digit - "0" does not appear in the label. It only shows 55111. how can I merged the six digit postal code properly without having to manually enter the digit "0" infront? the postal code number all comes with different numbers with some having digit "0" infront 10s community for the help  -- oldLearner57 |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
merging data from Excel with data having digit "0" infront
http://www.gmayor.com/formatting_word_fields.htm - please do not multipost!
-- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org oldLearner57 wrote: hi community when I merged data from excel e.g: 055111 as Postal Code using Mail Merge feature, the front digit - "0" does not appear in the label. It only shows 55111. how can I merged the six digit postal code properly without having to manually enter the digit "0" infront? the postal code number all comes with different numbers with some having digit "0" infront 10s community for the help |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
merging data from Excel with data having digit "0" infront
10s! Graham Mayor for the information given
n I did not multi-post intentionally, it was because after I posted into the Word section, than I realised that there is another section specifically for Mailmerge & Fax, therefore, I re-posted the question here m sorry for being not paying attention 10s community for the help rendered -- oldLearner57 "Graham Mayor" wrote: http://www.gmayor.com/formatting_word_fields.htm - please do not multipost! -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org oldLearner57 wrote: hi community when I merged data from excel e.g: 055111 as Postal Code using Mail Merge feature, the front digit - "0" does not appear in the label. It only shows 55111. how can I merged the six digit postal code properly without having to manually enter the digit "0" infront? the postal code number all comes with different numbers with some having digit "0" infront 10s community for the help |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| label merged with data having digit "0" infront | Microsoft Word Help | |||
| What are XML "data stores" and "bindings" in Word 2007? | Microsoft Word Help | |||
| Excel merge into Word:"unable to open data source" | Microsoft Word Help | |||
| ASP.NET - Excel - Mail Merge in Word causes "Data Link Properties" dialog to appear. | Mailmerge | |||
| Can't find "Microsoft Excel Worksheet Via Converter" as data sourc | Mailmerge | |||
Linear Mode
