MergeFields with Switches, is there a switch to backspace?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wattl@dneph.com - 08 Jun 2005 22:50 GMT

Is there a switch that lets you backspace when using MergeFields. For
example, I have a number pulls in 789789.0. I would like for it to
automatically backspace and get rid of the .0. There is no way in the base
system to change the format of this number.

Thank you,
LW

Reply to this Message

Greg Maxey - 08 Jun 2005 23:09 GMT

I don't think so. You could try a conditional field. Replace "REF Test"
with your mergefield value.

{ IF { =({ REF Test }-{ =INT({ REF Test }) }) } = "0" "{ REF Test \# ",0" }"
"{ REF Test \# "0.0" }" }

Signature

Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.

> Is there a switch that lets you backspace when using MergeFields. For
> example, I have a number pulls in 789789.0. I would like for it to
[quoted text clipped - 3 lines]
> Thank you,
> LW

Reply to this Message

wattl@dneph.com - 09 Jun 2005 15:16 GMT

Greg,

Thank you for the information but it did not work. I will do some more
research to see why it did not work. Looks like it should have.

Lisa

> I don't think so. You could try a conditional field. Replace "REF Test"
> with your mergefield value.
[quoted text clipped - 9 lines]
> > Thank you,
> > LW

Reply to this Message

Greg - 09 Jun 2005 16:21 GMT

Lisa,

I don't have a merge document to test with. The field construction
works here when tested using a REF field. Can you get it to work using
a REF field?

The format switches ",##0" and ",##0.##" may be better suited to your
needs.

Reply to this Message