View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
djcten djcten is offline
external usenet poster
 
Posts: 2
Default 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