merging excel document

[Shirl]

Excel Document has date 8/05/1953 when merged into Publisher it is 5/08/1953.
How do I get it to stay 8/05/1953 when merged?

 

[Mary Sauer]

Format the field text.

 

[Shirl]

Have Formated Date column in Excel. Seems to change in Mail Catalog Merge
when Recipients are entered. and will not go into Publisher Document under my
field DOB (Date of Birth), it always enters around the wrong way.
Could the problem be in the Mail Catalog Merge?
Have actually put the DOB column in Excel to the format "8 May 1953" but
still goes back to "5/08/1953" during the merge to publisher document.

 

[Ed Bennett]

Could the problem be in the Mail Catalog Merge?
Have actually put the DOB column in Excel to the format "8 May 1953" but
still goes back to "5/08/1953" during the merge to publisher document.

The problem is that Publisher's merge engine can't see the formatting
you've applied to the Excel field, only the data.

Try exporting as a CSV file (text only, no formatting masks, so what you
see is what you get) and merging against that instead of the Excel file.

 

[Shirl]

Thank you for your help. I am rather new to all this and not sure what a CSV
File is. But will work it out.

 

[Ed Bennett]

Thank you for your help. I am rather new to all this and not sure what a CSV
File is. But will work it out.

CSV is an acronym for Comma Separated Values. It's a type of plain text
file that stores basic spreadsheet/database information. Look for .csv
in the list of file types available in File > Save As in Excel.

 

[Shirl]

Extra thanks all went well. Worked a real treat.

CSV is an acronym for Comma Separated Values. It's a type of plain text
file that stores basic spreadsheet/database information. Look for .csv
in the list of file types available in File > Save As in Excel.