Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jul 2008
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    format wrong for excel currency data into word (2003, xp)

    I'm doing a merge in Word 03 with an Excel 03 data source. Two of the merge fields are date and a dollar amount (i.e. $124.37). The date is formatted correctly in Excel (April 7, 1997) but it pulls over like 4/7/97.

    The currency is formatted correctly as well in Excel but pulls over like 30000 for $30,000.00. How do I fix this? I've got over 400 letters and I'd hate to have to edit each one! Thanks, Sam

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: format wrong for excel currency data into word (2003, xp)

    You will find two different ways to solve this problem in <post:=755,224>post 755,224</post:>

    StuartR

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •