Format Merge Field

C

C Huff

I have a mergefield that can either be a whole number (i.e. 7), a number with
a decimal (i.e. 2.14), or a text field (i.e. 13,14,15 & 17).

I want to format them so that each type comes out as it appears above (7,
2.14, and 13,14,15, & 17).

Is there a way to format a merge field to accomodate this?

Thanks for your help.
 
M

macropod

Hi C Huff,

You can't do this by formatting the mergefield. You may be able to do by ensuring the first 8 rows of data for the field concerned
have text strings (eg 13,14,15 & 17). If that doesn't work and your decimal values are all of the same precision (eg 2 decimal
places) and they don't end in '.00' or '.0', a formula field could probably be constructed to do the work.
 

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 adding extra digits to merge 1
Merge Data - calculated field 2
Truncate a number using Numeric Format Switch 1
Decimal places in mail merge 1
Help with Formatting Percentages in Mail Merge Master Document 4
Date Format needs to change from Mail Merge 1
Merge Field w/Date 1
Mail merge between Word and Excel 1

Top