| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
problems using Excel as a mail merge database in Office XP
I had a very straightforward mail merge program that imported data from
an Excel file and produced form invoices in Word. I used to be able to set the date in Excel and import (say) 14 February 2006 now I get 38762 or some thing worse like 12345.6789. Previously I could Round and Format a cell for currency and get an answer like £12.34 which would import to word as £12.34 now it imports as 12.3456. My upgrade was from Office 2000 to Office XP. Can anyone advise how to fix this??? Regards David |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
problems using Excel as a mail merge database in Office XP
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 djcten wrote: I had a very straightforward mail merge program that imported data from an Excel file and produced form invoices in Word. I used to be able to set the date in Excel and import (say) 14 February 2006 now I get 38762 or some thing worse like 12345.6789. Previously I could Round and Format a cell for currency and get an answer like £12.34 which would import to word as £12.34 now it imports as 12.3456. My upgrade was from Office 2000 to Office XP. Can anyone advise how to fix this??? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
problems using Excel as a mail merge database in Office XP
Excellent solution thnx David
Debra Dalgleish wrote: 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 djcten wrote: I had a very straightforward mail merge program that imported data from an Excel file and produced form invoices in Word. I used to be able to set the date in Excel and import (say) 14 February 2006 now I get 38762 or some thing worse like 12345.6789. Previously I could Round and Format a cell for currency and get an answer like £12.34 which would import to word as £12.34 now it imports as 12.3456. My upgrade was from Office 2000 to Office XP. Can anyone advise how to fix this??? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
problems using Excel as a mail merge database in Office XP
You're welcome, and thanks for letting me know that it helped.
djcten wrote: Excellent solution thnx David Debra Dalgleish wrote: 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 djcten wrote: I had a very straightforward mail merge program that imported data from an Excel file and produced form invoices in Word. I used to be able to set the date in Excel and import (say) 14 February 2006 now I get 38762 or some thing worse like 12345.6789. Previously I could Round and Format a cell for currency and get an answer like £12.34 which would import to word as £12.34 now it imports as 12.3456. My upgrade was from Office 2000 to Office XP. Can anyone advise how to fix this??? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mail Merge w/ Shared Workbook in Word and Excel 2003 | Excel Discussion (Misc queries) | |||
| Mail Merge a Date from Excel to Word | Excel Discussion (Misc queries) | |||
| Using Excel for a Mail Merge | Excel Worksheet Functions | |||
| Link excel and word in mail merge without losing your data source? | Excel Discussion (Misc queries) | |||
| Excel database - merge to Word | Excel Worksheet Functions | |||
Hybrid Mode
