C Chaya Sep 15, 2008 #1 Example, instead of displaying 3/20/02 it displays 37335. How can I get word to format the data from excell as date.
Example, instead of displaying 3/20/02 it displays 37335. How can I get word to format the data from excell as date.
F Fred Smith Sep 15, 2008 #2 In your mail merge document, you likely can tell Word what number format you want (ie m/dd/yy). You could ask in the Word group about it. The simpler option, to me, is to format the merged data in Excel, using something like: =Text(a1,"m/dd/yy") Regards, Fred.
In your mail merge document, you likely can tell Word what number format you want (ie m/dd/yy). You could ask in the Word group about it. The simpler option, to me, is to format the merged data in Excel, using something like: =Text(a1,"m/dd/yy") Regards, Fred.
B Bruce Sinclair Sep 16, 2008 #3 In your mail merge document, you likely can tell Word what number format you want (ie m/dd/yy). You could ask in the Word group about it. The simpler option, to me, is to format the merged data in Excel, using something like: =Text(a1,"m/dd/yy") Click to expand... Alternatively, try connecting to your excel file using DDE. That fixed a number of formatting problems in the final word doc for me.
In your mail merge document, you likely can tell Word what number format you want (ie m/dd/yy). You could ask in the Word group about it. The simpler option, to me, is to format the merged data in Excel, using something like: =Text(a1,"m/dd/yy") Click to expand... Alternatively, try connecting to your excel file using DDE. That fixed a number of formatting problems in the final word doc for me.