playvur.blogg.se

I cannot determine what is making these Excel data in these particular columns behave differently than the same data in another column.

This is highly impractical when the number of records is more than just a few. This effectively makes it a text cell, and the mailmerge formatting will pick up the date and display it properly. I have found a workaround by going to each problem date cell and inserting a ‘ before the date. But for some reason, these particular cells will not display in the merge doc as dates. The date cells are all formatted exactly the same in Excel, and the mergefields are switch-formatted the same in the merge document. 43159 for ) regardless of the fact that the mergefield switches are set to format the info as mm/dd/yy.Īll other date fields in the spreadsheet display correctly in the merge doc. I have two date fields in an Excel 2016 spreadsheet that will merge only as the numeric date value (e.g.