LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format cell in column B based on value in the next cell (column c) Nicole Excel Discussion (Misc queries) 7 May 18th 05 10:19 PM
Merging data from an excel worksheet into an excel template pkasler Excel Worksheet Functions 1 March 13th 05 04:36 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Can I mail merge filtered data on an Excel spreadsheet to a word d Matt Squires Excel Worksheet Functions 1 November 10th 04 05:16 PM
getting data from 2 excel sheets automatically pinar Excel Worksheet Functions 0 November 9th 04 11:47 AM


All times are GMT +1. The time now is 07:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"