Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge % format
I have percents in my excel database and I want them to mail merge into Word
but they don't stay percents. I need a Switch that will merge my percent data. For example I have 3.00% in excel and when I merge it into Word, I want it to show as 3.00%. Please help. thank you! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge % format
If your existing field is something like
{ MERGEFIELD mynumber } (use Alt-F9 to toggle the field code/field result display) and the result you are seeing is something like "3", then a. delete any "switches" like \*Mergeformat b. type in a switch like \#"0.00%" so you have { MERGEFIELD mynumber \#"0.00%" } However, I think it is more likely that you are seeing something like 0.03, in which case you need to multiply by 100 first, e.g. { ={ MERGEFIELD mynumber }*100 \#"0.00%" } Both sets of field code braces {} need to be the sort you can insert using ctrl-F9, not the ones you enter directly on the keyboard. Peter Jamieson http://tips.pjmsn.me.uk Red wrote: I have percents in my excel database and I want them to mail merge into Word but they don't stay percents. I need a Switch that will merge my percent data. For example I have 3.00% in excel and when I merge it into Word, I want it to show as 3.00%. Please help. thank you! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge % format
"Peter Jamieson" wrote: If your existing field is something like { MERGEFIELD mynumber } (use Alt-F9 to toggle the field code/field result display) and the result you are seeing is something like "3", then a. delete any "switches" like \*Mergeformat b. type in a switch like \#"0.00%" so you have { MERGEFIELD mynumber \#"0.00%" } However, I think it is more likely that you are seeing something like 0.03, in which case you need to multiply by 100 first, e.g. { ={ MERGEFIELD mynumber }*100 \#"0.00%" } Both sets of field code braces {} need to be the sort you can insert using ctrl-F9, not the ones you enter directly on the keyboard. Peter Jamieson http://tips.pjmsn.me.uk Red wrote: I have percents in my excel database and I want them to mail merge into Word but they don't stay percents. I need a Switch that will merge my percent data. For example I have 3.00% in excel and when I merge it into Word, I want it to show as 3.00%. Please help. thank you! |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge % format
Peter, I can't thank you enough! I had tried for hours to get this to work
using that formula but I was missing one thing that you told me about, that the brackets needed to be entered by using control + F9! Thanks so much! "Peter Jamieson" wrote: If your existing field is something like { MERGEFIELD mynumber } (use Alt-F9 to toggle the field code/field result display) and the result you are seeing is something like "3", then a. delete any "switches" like \*Mergeformat b. type in a switch like \#"0.00%" so you have { MERGEFIELD mynumber \#"0.00%" } However, I think it is more likely that you are seeing something like 0.03, in which case you need to multiply by 100 first, e.g. { ={ MERGEFIELD mynumber }*100 \#"0.00%" } Both sets of field code braces {} need to be the sort you can insert using ctrl-F9, not the ones you enter directly on the keyboard. Peter Jamieson http://tips.pjmsn.me.uk Red wrote: I have percents in my excel database and I want them to mail merge into Word but they don't stay percents. I need a Switch that will merge my percent data. For example I have 3.00% in excel and when I merge it into Word, I want it to show as 3.00%. Please help. thank you! |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge % format
Peter, I can't thank you enough! I had tried for hours to get this to work
using that formula but I was missing one thing that you told me about, that the brackets needed to be entered by using control + F9! Thanks so much! "Peter Jamieson" wrote: If your existing field is something like { MERGEFIELD mynumber } (use Alt-F9 to toggle the field code/field result display) and the result you are seeing is something like "3", then a. delete any "switches" like \*Mergeformat b. type in a switch like \#"0.00%" so you have { MERGEFIELD mynumber \#"0.00%" } However, I think it is more likely that you are seeing something like 0.03, in which case you need to multiply by 100 first, e.g. { ={ MERGEFIELD mynumber }*100 \#"0.00%" } Both sets of field code braces {} need to be the sort you can insert using ctrl-F9, not the ones you enter directly on the keyboard. Peter Jamieson http://tips.pjmsn.me.uk Red wrote: I have percents in my excel database and I want them to mail merge into Word but they don't stay percents. I need a Switch that will merge my percent data. For example I have 3.00% in excel and when I merge it into Word, I want it to show as 3.00%. Please help. thank you! |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge % format
My pleasure, Red.
Peter Jamieson http://tips.pjmsn.me.uk Red wrote: Peter, I can't thank you enough! I had tried for hours to get this to work using that formula but I was missing one thing that you told me about, that the brackets needed to be entered by using control + F9! Thanks so much! "Peter Jamieson" wrote: If your existing field is something like { MERGEFIELD mynumber } (use Alt-F9 to toggle the field code/field result display) and the result you are seeing is something like "3", then a. delete any "switches" like \*Mergeformat b. type in a switch like \#"0.00%" so you have { MERGEFIELD mynumber \#"0.00%" } However, I think it is more likely that you are seeing something like 0.03, in which case you need to multiply by 100 first, e.g. { ={ MERGEFIELD mynumber }*100 \#"0.00%" } Both sets of field code braces {} need to be the sort you can insert using ctrl-F9, not the ones you enter directly on the keyboard. Peter Jamieson http://tips.pjmsn.me.uk Red wrote: I have percents in my excel database and I want them to mail merge into Word but they don't stay percents. I need a Switch that will merge my percent data. For example I have 3.00% in excel and when I merge it into Word, I want it to show as 3.00%. Please help. thank you! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number Format in Mailmerge | Mailmerge | |||
address format in mailmerge | Mailmerge | |||
Format numbers from mailmerge | Mailmerge | |||
Mailmerge date format | Mailmerge | |||
MailMerge format | Mailmerge |