I have a problem when doing the mail merge with Office 2003.

Question

First of all, I wrote a letter in Word 2003 and then try to merge some data from Excel 2003. The data in Excel column was listed as below:

A1=101
A2=123
A3=134
A4=148A
A5=181B

Problem:
The data of A4 & A5 in recipient list are changed to 0 instead of the original ones.

Question:
How can I show "148A" and "181B" in Word 2003 (recipient list) when mail merging with such data?
(I've tried to add ' in front of those data in order to convert them into TEXT format, it works. But I have too many data to make it by manual.
Do you have any other solution instead?)

Answer 1

I've never had success using the mail merge with Word and Excel, so I would press the F1 key in each program, find the directions for mail merge, and print the directions out. Then I'd try again.

Answer 2

Thanks for both of your help.

It is quite confusing.
It becomes normal when I do it at home.
It means that the problem is not happened in computer A but B.
(Is it a setting Problem, if yes, how to solve it pls?)

My friend advise me to add ' in front of the data. It works.
But I have a lot of data, it is quite hard to add it one by one, do you have any other idea?