Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
I'm not sure if this question should be in word or excel forums, so let me
know. I have created a spreadsheet that pulls data from an excel sheet to complete the merge. One of the cells that transfers over is a formula that calculates a score. I want the merge to show the number that's in the cell. The cells are formatted to show through one decimal space. When I merge over, it shows the entire number that excel calculates. I can't figure out if I need to change the excel cells, or the word merge document to just show the numbers through the first decimal. Any help would be great. If you need the formula to see where to put it it's: =IF('MidMod Grades+Att.'!H3="","",'MidMod Grades+Att.'!H3) Thank you for any help. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge from Excel
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps, Doug Robbins - Word MVP Please reply only to the newsgroups unless you wish to obtain my services on a paid professional basis. "mdj0615" wrote in message ... I'm not sure if this question should be in word or excel forums, so let me know. I have created a spreadsheet that pulls data from an excel sheet to complete the merge. One of the cells that transfers over is a formula that calculates a score. I want the merge to show the number that's in the cell. The cells are formatted to show through one decimal space. When I merge over, it shows the entire number that excel calculates. I can't figure out if I need to change the excel cells, or the word merge document to just show the numbers through the first decimal. Any help would be great. If you need the formula to see where to put it it's: =IF('MidMod Grades+Att.'!H3="","",'MidMod Grades+Att.'!H3) Thank you for any help. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Word Mail Merge from Excel -- Force Excel to open the datafile? | Mailmerge | |||
ExcelWord Mail merge transfers 16 digits when Excel shows only 3 | Mailmerge | |||
mail merge from excel-date in excel January 1, 2005 -merged dbase. | Mailmerge | |||
How to convert a mail merge document back to excel after mail mer | Microsoft Word Help | |||
Insert Merge Field problem with Word-Mail Merge from Excel documen | Microsoft Word Help |