|One option is to cheat: On the excel spreadsheet, put in a cell with the following formula (assuming cell A2 is the date in normal format).|
use your specified date format. This will make the cell come in as text rather than as a date. As long as it appears correctly in Excel, it should transfer to your word document exactly the same.
Bit tricky otherwise. I know it's possible to save Excel with different date formats, but this is tied to an individual workbook. Are you getting data from two different workbooks? Might be worth re-saving them.
Hope this helps!