Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
oldLearner57 oldLearner57 is offline
external usenet poster
 
Posts: 24
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
oldLearner57 oldLearner57 is offline
external usenet poster
 
Posts: 24
Default 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

Posting Rules

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
label merged with data having digit "0" infront oldLearner57 Microsoft Word Help 1 August 23rd 08 03:22 PM
What are XML "data stores" and "bindings" in Word 2007? funnybroad Microsoft Word Help 2 February 20th 08 02:13 AM
Excel merge into Word:"unable to open data source" STEVE Microsoft Word Help 3 September 21st 07 02:58 PM
ASP.NET - Excel - Mail Merge in Word causes "Data Link Properties" dialog to appear. [email protected] Mailmerge 1 April 18th 06 02:38 PM
Can't find "Microsoft Excel Worksheet Via Converter" as data sourc Joelle Faulks Mailmerge 7 December 8th 05 09:11 PM


All times are GMT +1. The time now is 11:00 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"