View Single Post
  #1   Report Post  
Red
 
Posts: n/a
Default Column format when merging Excel data to Word labels

I have a four column Excel spreadsheet which I have Mail Merged into Word to
create labels.
One of the columns in Excel contains a list of four digit numbers. Some of
those numbers begin with a zero.
When I have merged the data into Word labels, the four digit numbers
starting with a zero have the zero missing.
I have tried all sorts of number formats in Excel but can't get the zeros to
stay there when merged to Word.
Can anyone help???? I'm using Office 2003.