How can I format phone numbers in Publisher?

X

xrayjohn

My data was entered in Access using an input mask. When merged in Publisher,
the mask is not preserved. (___)___-____ is the mask. The data comes out
like: 0000000000
 
D

Debbie [MSFT]

From article 212702 PUB2000: Date and Number Formats Change During Mail
Merge
http://support.microsoft.com/?id=212702:

Most programs that create databases and spreadsheets have a feature
to save as a delimited text file. If you export a database or
spreadsheet as a text file, the text file contains the result of the
input masks, not the raw data.
 

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

Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Phone Number Retrieval 4
Importing data with formatting mask 2
Time format hh:nn drops leading zero 0
Formatting issue with imported telephone number! 2
Printing Outline view - formatting lost 0
changing the Phone Number Input Mask to all for extensions 2
Access Input Mask for phone number 2

Top