Ask a new question

Word 2010 mail merge alphabet is appeared as zero (0) after merge it with data source in Excel

Hi, my IC either consists of alphabet or number.  However, I cannot get the IC whereby it consists of alphabet after mail merge to word.  My data source is in excel as follow.

IC (number): 4321390, it appeared in word
IC (alphabet): A0589424, it appeared as 0

Please advise. Thank you.


Answer
Answer
This is liable to occur when you have mixed numeric and alpha-numeric data in the same field. For an explanation and possible workarounds, see: http://tips.pjmsn.me.uk/t0003.htm
Cheers
Paul Edstein
(Fmr MS MVP - Word)

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated October 5, 2021 Views 231 Applies to: