Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Mergefield?
Hi,
I have an Excel 2000 datasource which merges it's data into Word 2000. I do this by taking the data from sql server putting into VB doing my calculations and then performing the mail merge. Problem I'm having is when using percentages, when I open up my datasource it is displaying as i.e. 40% but it is going into Word as 0.4 because of the formatting in Excel. Is there any way I can get the merge fields in Word to display the datasource fields as they look in Excel? Would appreciate any help on this. Thanks Damon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Mergefield?
Hi
I tried this with the same versions of excel and word and the percentage formatting was copied through to the merge field without me having to do anything. Another solution would be to show the percentages as integers in the database ie 15 instead of .15 with standard number formatting and add the percentage switch to the merge field in Word. {MERGEFIELD <percent\# ##%} (Where <percent is the field name of your percentage in your database). Hope this helps. -----Original Message----- Hi, I have an Excel 2000 datasource which merges it's data into Word 2000. I do this by taking the data from sql server putting into VB doing my calculations and then performing the mail merge. Problem I'm having is when using percentages, when I open up my datasource it is displaying as i.e. 40% but it is going into Word as 0.4 because of the formatting in Excel. Is there any way I can get the merge fields in Word to display the datasource fields as they look in Excel? Would appreciate any help on this. Thanks Damon . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Mergefield?
Hi,
Why didn;t I think of that?! Thank you very much, that has sorted out my problem. Damon "Nick" wrote in message ... Hi I tried this with the same versions of excel and word and the percentage formatting was copied through to the merge field without me having to do anything. Another solution would be to show the percentages as integers in the database ie 15 instead of .15 with standard number formatting and add the percentage switch to the merge field in Word. {MERGEFIELD <percent\# ##%} (Where <percent is the field name of your percentage in your database). Hope this helps. -----Original Message----- Hi, I have an Excel 2000 datasource which merges it's data into Word 2000. I do this by taking the data from sql server putting into VB doing my calculations and then performing the mail merge. Problem I'm having is when using percentages, when I open up my datasource it is displaying as i.e. 40% but it is going into Word as 0.4 because of the formatting in Excel. Is there any way I can get the merge fields in Word to display the datasource fields as they look in Excel? Would appreciate any help on this. Thanks Damon . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|