Using Catalog Merge

S

Sharon

I'm using catalog merge to create a directory from an excel spreadsheet. The
phone numbers in the spreadsheet are using the special cell formatting for
phone numbers. is there a way to bring this formatting into publisher? Right
now the phone numbers are merging into the directory as 1234657890 instead of
(123)456-7890
 
S

Sharon

Thanks for the help but that would require me to re-enter all the phone
numbers.
 
M

Mary Sauer

Save the database as a .csv. (comma delimited). I am not an Excel person. Maybe
someone in the Excel newsgroup will be more helpful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Contact Phone Number Auto Format 0
Mail Merge Document Type 1
Catalog merge prints a '0' instead of my merged text 1
How to auto-scale images in catalog merge 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Formatting Phone Numbers in Excel 2007 Help 16

Top