Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Currency format - Excel to Word Merge
0 views
Skip to first unread message
ckkelliej
Nov 28, 2005, 10:04:04 PM11/28/05
to
How do I format my form letter so that the cents only show if there are
cents? ie "$5,459.50" is ok but "$5,000.00" should be simply "$5,000".
I assume I need to use an "If" switch??
cents? ie "$5,459.50" is ok but "$5,000.00" should be simply "$5,000".
I assume I need to use an "If" switch??
Greg Maxey
Nov 28, 2005, 10:15:04 PM11/28/05
to
Try putting your result in a formula field.
{ =({MergeField Whatever})}
--
Greg Maxey/Word MVP
See:
http://gregmaxey.mvps.org/word_tips.htm
For some helpful tips using Word.
0 new messages