Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting problem in dollar fields
I am trying to do a merge where I import several fields, some of which are
dollar amounts. I've done this successfully several times in the last few years, but now all I get are plain numbers instead of dollar amounts. I don't want to put $ in every field, because if the field is blank I want it to be blank. I am copying data out of Access into Excel, then using the Excel spreadsheet for my data file. In Excel the formatting of the dollar fields shows a custom field of $#,##0.00;($#,##0.00). This is exactly the same as when I did this two years ago. The only difference between then and now is my version of Office. Then was 2002, now I have 2003. Is my new version of Office trying to "help" me, but actually making it more difficult on me? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting problem in dollar fields
Do you have any numeric formatting switches (like \#"$,0.00" in your Word
mail merge main document? (Use Alt-F9 to look at the field codes. If not, it sounds as if the connection method used may have changed from DDE (which would display what you entered in Excel, more or less) to OLEDB, which is the default for both Word 2002/2003 and needs suitable field switches in Word to format the amounts correctly. If so, you can switch back to DDE by checking Word Tools|Options|general|Confirm conversion at open and re-connecting to the data source, or put appropriate formatting switches into your fields. Peter Jamieson "Tom" wrote in message ... I am trying to do a merge where I import several fields, some of which are dollar amounts. I've done this successfully several times in the last few years, but now all I get are plain numbers instead of dollar amounts. I don't want to put $ in every field, because if the field is blank I want it to be blank. I am copying data out of Access into Excel, then using the Excel spreadsheet for my data file. In Excel the formatting of the dollar fields shows a custom field of $#,##0.00;($#,##0.00). This is exactly the same as when I did this two years ago. The only difference between then and now is my version of Office. Then was 2002, now I have 2003. Is my new version of Office trying to "help" me, but actually making it more difficult on me? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Formatting problem in dollar fields
Hi Tom,
You can fix this by adding a picture switch to the mergefield. For example: .. select the errant field .. press Shift-F9 to expose the code (which will look something like {MERGEFIELD ExcelVal} .. change the field code to {MERGEFIELD ExcelVal \# $,0.00;($,0.00)} .. run your mailmerge. Cheers "Tom" wrote in message ... I am trying to do a merge where I import several fields, some of which are dollar amounts. I've done this successfully several times in the last few years, but now all I get are plain numbers instead of dollar amounts. I don't want to put $ in every field, because if the field is blank I want it to be blank. I am copying data out of Access into Excel, then using the Excel spreadsheet for my data file. In Excel the formatting of the dollar fields shows a custom field of $#,##0.00;($#,##0.00). This is exactly the same as when I did this two years ago. The only difference between then and now is my version of Office. Then was 2002, now I have 2003. Is my new version of Office trying to "help" me, but actually making it more difficult on me? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Ref fields to look like hyperlinks | Microsoft Word Help | |||
Formatting problem in Word 2000 | Page Layout | |||
Formatting Problem | New Users | |||
Form Fields lose bold formatting | Microsoft Word Help | |||
standard and formatting toolbars on two rows problem | Microsoft Word Help |