| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formating Mail Merge of 10 digit numbers to have parenthasis+dash
I have a database on Lotus and want to merge phone numbers. The phone numbers
in the database are 10 digits (XXXXXXXXXX) and I want to merge them so that it shows up (XXX) XXX-XXXX, with parenthasis and a dash. Is this possible? Also I have 9 digit Zip codes with the same problem. I have XXXXXXXXX in the database, but want to format the merge so that XXXXX-XXXX shows up with the dash. Any help is much appreceated. |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail merge using Excel's calculated numbers | Mailmerge | |||
| Numbers are continuing on every mail merge letter txt box; want 1, | Mailmerge | |||
| mail merge with attachments | Mailmerge | |||
| Mail Merge should allow you to use numbers and text within the sa. | Mailmerge | |||
| Numbers reformatting during mail merge | Formatting Long Documents | |||
Threaded Mode