Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Currency format - Excel to Word Merge
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?? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Currency format - Excel to Word Merge
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. ckkelliej wrote: 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?? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get rid of page numbers. The page number virus | Microsoft Word Help | |||
In Word, how can I see all files (*.*) in "save as"? | New Users | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Format Excel data for merging in Word | Mailmerge | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help |