Cell formatting in Mail Merge
I have an Excel spreadsheet, showing dates when a succession of different
stages are reached for each client in my conveyancing job. All dates are in
UK format in Excel. However, when I mail merge in Word using this data
source, all dates appear in Word as US format, and any empty cells are
populated with 12:00AM.
Could you please tell me if this is an Excel problem, and what the solution
may be.
|