Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge Problems
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 in word. 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.excel.worksheet.functions
|
|||
|
|||
Merge Problems
You can change it in Word using Field Formatting
Or use a helper cell in Excel. =TEXT(IF('MidMod Grades+Att.'!H3="","",'MidMod Grades+Att.'!H3),#,##0.0") Gord Dibben MS Excel MVP On Mon, 18 Jan 2010 13:53:01 -0800, mdj0615 wrote: 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 in word. 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Merge Problems
You can either tackle it at the Excel end, and use =IF('MidMod
Grades+Att.'!H3="","",TEXT('MidMod Grades+Att.'!H3,"#.0")) or do the formatting in Word: Mail merge Excel to Word: a.. http://www.mvps.org/dmcritchie/excel/mailmerg.htm b.. http://www.mvps.org/word/FAQs/MailMerge c.. http://office.microsoft.com/en-ca/as...164951033.aspx d.. http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm e.. news:microsoft.public.word.mailmerge.fields -- David Biddulph "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 in word. 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 | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problems using Excel as a mail merge database in Office XP | Excel Worksheet Functions | |||
mail merge problems | Setting up and Configuration of Excel | |||
I have problems keeping the merge formula to use as a template. | Excel Discussion (Misc queries) | |||
MAIL MERGE PROBLEMS | Excel Discussion (Misc queries) | |||
merge data problems | Excel Worksheet Functions |