Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Hi,
I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Bruce
You will it doesn't travel by any of the transport methods for mailmerge (DDE or ODBC) You will need to transfer the data to text. I use a helper column and the TEXT function and then kill the formula with paste special+Values =TEXT(B1,"£#,##0.00") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Perkgolf" wrote in message ... Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Debra Dalgleish posted this:
There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. Perkgolf wrote: Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Thanks. I'll try that.
Bruce "Dave Peterson" wrote: Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. Perkgolf wrote: Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Thanks Nick for the help
Bruce "Nick Hodge" wrote: Bruce You will it doesn't travel by any of the transport methods for mailmerge (DDE or ODBC) You will need to transfer the data to text. I use a helper column and the TEXT function and then kill the formula with paste special+Values =TEXT(B1,"£#,##0.00") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Perkgolf" wrote in message ... Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Nick,
I am using Word 2007 and Excel 2007. When I try to use ODBC as the transport method for the Mail Merge in Word, it still does not bring the currency formatting over from Excel to Word. I have clicked the Confirm Data Source Box located under Word Options, select the ODBC connection option, selected the worksheet that contains the data, and even restarted my computer. Is there something else that needs to be done in order to make the currency formating transport from Excel 2007 to the Word 2007 Mail Merge? -- disbell "Nick Hodge" wrote: Bruce You will it doesn't travel by any of the transport methods for mailmerge (DDE or ODBC) You will need to transfer the data to text. I use a helper column and the TEXT function and then kill the formula with paste special+Values =TEXT(B1,"£#,##0.00") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Perkgolf" wrote in message ... Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
I'm not Nick and I don't use Office 2007 enough to help. So this may be a waste
of your time... Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) disbell wrote: Nick, I am using Word 2007 and Excel 2007. When I try to use ODBC as the transport method for the Mail Merge in Word, it still does not bring the currency formatting over from Excel to Word. I have clicked the Confirm Data Source Box located under Word Options, select the ODBC connection option, selected the worksheet that contains the data, and even restarted my computer. Is there something else that needs to be done in order to make the currency formating transport from Excel 2007 to the Word 2007 Mail Merge? -- disbell "Nick Hodge" wrote: Bruce You will it doesn't travel by any of the transport methods for mailmerge (DDE or ODBC) You will need to transfer the data to text. I use a helper column and the TEXT function and then kill the formula with paste special+Values =TEXT(B1,"£#,##0.00") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Perkgolf" wrote in message ... Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Nick,
I am using Word 2007 and Excel 2007. When I try to use ODBC as the transport method for the Mail Merge in Word, it still does not bring the currency formatting over from Excel to Word. I have clicked the Confirm Data Source Box located under Word Options, select the ODBC connection option, selected the worksheet that contains the data, and even restarted my computer. Is there something else that needs to be done in order to make the currency formating transport from Excel 2007 to the Word 2007 Mail Merge? -- disbell -- disbell "Nick Hodge" wrote: Bruce You will it doesn't travel by any of the transport methods for mailmerge (DDE or ODBC) You will need to transfer the data to text. I use a helper column and the TEXT function and then kill the formula with paste special+Values =TEXT(B1,"£#,##0.00") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Perkgolf" wrote in message ... Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Dave,
Thank you for your response. I found a way to format using text, but this might not be my best option since the currency field in the spreadsheet may need to be used for calculations. Thanks again for your response. -- disbell "Dave Peterson" wrote: I'm not Nick and I don't use Office 2007 enough to help. So this may be a waste of your time... Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) disbell wrote: Nick, I am using Word 2007 and Excel 2007. When I try to use ODBC as the transport method for the Mail Merge in Word, it still does not bring the currency formatting over from Excel to Word. I have clicked the Confirm Data Source Box located under Word Options, select the ODBC connection option, selected the worksheet that contains the data, and even restarted my computer. Is there something else that needs to be done in order to make the currency formating transport from Excel 2007 to the Word 2007 Mail Merge? -- disbell "Nick Hodge" wrote: Bruce You will it doesn't travel by any of the transport methods for mailmerge (DDE or ODBC) You will need to transfer the data to text. I use a helper column and the TEXT function and then kill the formula with paste special+Values =TEXT(B1,"£#,##0.00") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Perkgolf" wrote in message ... Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
How about storing the value in the cell, then use =text() in another cell to
format the value (into text) the way you want. Then use mailmerge with that helper field. disbell wrote: Dave, Thank you for your response. I found a way to format using text, but this might not be my best option since the currency field in the spreadsheet may need to be used for calculations. Thanks again for your response. -- disbell "Dave Peterson" wrote: I'm not Nick and I don't use Office 2007 enough to help. So this may be a waste of your time... Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. ========== I often cheat instead of racking my brain. I'll insert another column (probably hidden!) and use: =text(a2,"00000") (or whatever format I want) and use that field in the mailmerge. (Cheating doesn't bother me anymore <vbg.) disbell wrote: Nick, I am using Word 2007 and Excel 2007. When I try to use ODBC as the transport method for the Mail Merge in Word, it still does not bring the currency formatting over from Excel to Word. I have clicked the Confirm Data Source Box located under Word Options, select the ODBC connection option, selected the worksheet that contains the data, and even restarted my computer. Is there something else that needs to be done in order to make the currency formating transport from Excel 2007 to the Word 2007 Mail Merge? -- disbell "Nick Hodge" wrote: Bruce You will it doesn't travel by any of the transport methods for mailmerge (DDE or ODBC) You will need to transfer the data to text. I use a helper column and the TEXT function and then kill the formula with paste special+Values =TEXT(B1,"£#,##0.00") -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "Perkgolf" wrote in message ... Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce -- Dave Peterson -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
I had this problem also and found a solution that makes it work the correct
way. From Word, Click on the Microsoft Office Button, click on Work Option (lower right hand corner), click advanced, move down to the General area and check Confirm File Format Conversion on Open. I did this and now it works perfectly. "Perkgolf" wrote: Thanks. I'll try that. Bruce "Dave Peterson" wrote: Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. Perkgolf wrote: Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce -- Dave Peterson |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
Rosie,
That was a great tip! Thank you very much! There's only one thing that you didn't mentioned and might be useful for others: When you select your list from excel, a "Confirm Data Source" screen appears and you HAVE to activate the "Show all" mark and other options will appear at the "Open Data Source" space. Then you can choose the "Excel Worksheets via DDE" option. "rosie" wrote: I had this problem also and found a solution that makes it work the correct way. From Word, Click on the Microsoft Office Button, click on Work Option (lower right hand corner), click advanced, move down to the General area and check Confirm File Format Conversion on Open. I did this and now it works perfectly. "Perkgolf" wrote: Thanks. I'll try that. Bruce "Dave Peterson" wrote: Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. Perkgolf wrote: Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce -- Dave Peterson |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
I lose my number formatting in the mail merge?
I have also tried various methods, but to no avail.
My database is SQL and all the currency fields come with 4 decimals. I have tried the numeric switch as follows but do not get the desired result {MERGEFIELD rate_with_meal_plan \# #,0.00} Please help "Perkgolf" wrote: Hi, I'm losing my number formatting when I merge my Excel sheet into my Word doc? Any ideas? Thanks Bruce |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
Losing cell formatting as a result of a mail merge | Excel Discussion (Misc queries) | |||
How come Word is adding zeros to a mail merge number from Excel? | Excel Worksheet Functions | |||
Cell formatting in Mail Merge | Excel Discussion (Misc queries) | |||
How do you keep Excel currency formatting during a mail merge? | Excel Discussion (Misc queries) |