Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
removing first character in mergefields
I am trying to do a calculation with merge field data. However, my data is a
formatted number with a $ at the beginning. Changing the original data to a number only is not an option. I am working with Word 2003. By reading earlier posts I have figured how to do the actual calc I just don't know how to get it to ignore the preceding $. Data: $875.00 Would like to take monthly amount and calc annual amount {= {MERGEFIELD Rent_Mnth} * 12 \# "$,0.00"} Cannot calc due to $. Thank you in advance for your assistance. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
removing first character in mergefields
Using a Word data source, with data such as $875.00 and a calculation field
{= {MERGEFIELD Rent_Mnth} * 12 \# "$,0.00"} the calculation is performed OK here. What is your data source? Did you use Ctrl+F9 to insert the field delimiters { }? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Gladriella" wrote in message ... I am trying to do a calculation with merge field data. However, my data is a formatted number with a $ at the beginning. Changing the original data to a number only is not an option. I am working with Word 2003. By reading earlier posts I have figured how to do the actual calc I just don't know how to get it to ignore the preceding $. Data: $875.00 Would like to take monthly amount and calc annual amount {= {MERGEFIELD Rent_Mnth} * 12 \# "$,0.00"} Cannot calc due to $. Thank you in advance for your assistance. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
removing first character in mergefields
Data Source: Independent database. Also database is running the merge into
saved Word template. database field set to be a number with particular formatting. Internal calcs in database are based on this field as number. Yes Ctrl-F9 was used to insert both sets of {} When said database runs the merge final doc says {=$875.00*12 \# $,0.00"} Toggled :!Syntax Error, " Rent_Mnth returns correct value. No calc performed. Also, looks like merged doc still has fields. "Doug Robbins - Word MVP" wrote: Using a Word data source, with data such as $875.00 and a calculation field {= {MERGEFIELD Rent_Mnth} * 12 \# "$,0.00"} the calculation is performed OK here. What is your data source? Did you use Ctrl+F9 to insert the field delimiters { }? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Gladriella" wrote in message ... I am trying to do a calculation with merge field data. However, my data is a formatted number with a $ at the beginning. Changing the original data to a number only is not an option. I am working with Word 2003. By reading earlier posts I have figured how to do the actual calc I just don't know how to get it to ignore the preceding $. Data: $875.00 Would like to take monthly amount and calc annual amount {= {MERGEFIELD Rent_Mnth} * 12 \# "$,0.00"} Cannot calc due to $. Thank you in advance for your assistance. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MergeFields | Mailmerge | |||
Removing a Character Style | Microsoft Word Help | |||
Removing chevrons from MergeFields | New Users | |||
MERGEFIELDS | Mailmerge | |||
FormattingText, removing characters and keeping character formats.? | Tables |