| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Conditional Currency/Text Field Format in Merge
I have a field in an Excel spreadsheet that can be either currency or text.
I mail-merge it into a Word document. The field contains donation info, which may be things like "$25.00" or "4 tickets to ABC Theater". When I add the switch to get the currency to format correctly, it messes up the format when the field contains text. If I get the $25.00 to format correctly after the merge, "4 tickets to ABC Theater" looks like "$4.00". Without the switch, the "4 tickets to ABC Theater" looks good, but the "25.00" is "25". Any suggestions? Thanks! |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i format conditional text in a word mail merge | Mailmerge | |||
| Currency format - Excel to Word Merge | Microsoft Word Help | |||
| Access currency field wont format correctly in word mail merge | Mailmerge | |||
| Currency fields in Access lose th currency format whn merged why | Mailmerge | |||
| How do I format a merge field as Currency or %? | Mailmerge | |||
Threaded Mode