1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.WORD.MAI

  • Mail Merge Simple Calculation Error

    From ZachG3@21:1/5 to All on Tue Jun 12 00:38:38 2018
    I am having an issue with trying to multiply the number from the
    database by 1.2

    I think the issue might be that the number is coming through with a
    dollar sign in front of it (Ex: $343,000) and the mergefield may be
    reading it as text, rather than a number.

    Can anyone help with this?

    Thanks.




    --
    ZachG3
    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From ZachG3@21:1/5 to All on Tue Jun 12 16:16:11 2018
    Charles K. Kenyon;497358 Wrote:
    Simplest method is to change the source to a real number.

    I am not able to do that. Is there any way to drop the dollar sign
    within the merge field?




    --
    ZachG3
    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)