Change the "Insert Function" display for mail merge
I have entered times into a spreadsheet which have been formatted to hh:mm.
They show up in the cells correctly, but in the function line (fx) they show
up as hh:mm:ss AM or PM, respectively. When I do a mail merge, the time that
is brought into the merged document is what is showing in the function line.
How do I get it to bring the data that is being displayed in the cell?
Example: 6:00 PM shows in cell.......06:00:00 PM shows in the function line
and this is what gets merged into the Word document.
|