Prev: line over numbers
Next: Paper Sources
From: C Huff on 9 Feb 2010 09:47
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.
From: macropod on 9 Feb 2010 22:09
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.


--
Cheers
macropod
[Microsoft MVP - Word]


"C Huff" <CHuff(a)discussions.microsoft.com> wrote in message news:5E445264-E030-45A1-B7B0-297F9B08434D(a)microsoft.com...
>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.

 | 
Pages: 1
Prev: line over numbers
Next: Paper Sources