I am using an Excel spreadsheet for mail-merging into a Word letter.

In one of the Excel columns are a few house names. When merging into Word
these names change into 0.

I have looked under Format, Cells but this is set to General. Have also
tried changing this into Text still does not work.

I have also typed ' before the name of the house but again this changes to 0
in Word.