Dropped zeros when merging

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Excel data to merge into a Word document. I have class years such
as 02, 04 that need to be printed in the merge but the zeros are being
dropped. I've tried formatting several different ways but no success. Any
ideas?

Thanks!
 
With Word & Excel XP, I have no problem merging 02 & 04 so long as the values
reside in cells formatted as text. If the cells contain the numbers 2 and 4,
formatted to APPEAR as 02 & 04, then you get only the cells' contents - 2 and
4

So - format your cells as Text, and enter the values as 02, 04, etc
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to merge Excel address columns when some zips begin with zeros 4
Data lost in merge from Excel to Word 2
Excel 2007 not retaining formatting in mail merge operation 3
Mail Merge with Excel and Word 1
Mail Merge drops 1st digit ("0") converting from Excel to Word 3
Mail Merge Formating Issues 3
How do I add an apostrophe in front of existing column in Excel? 2
Mail merge in Excel 1

Back
Top