Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] robo@gobluemail.com is offline
external usenet poster
 
Posts: 38
Default Mail Merge Currency Issue

I'm creating a mail merge and my data is in Excel format. The data comes to
me from People Soft.

The problem I'm having is the currency amounts are having extra numbers
added on at the end once they arrive in word.

ie 45.3333 in Excel ends up looking like 45.333300000000001 in Word.

when formatted

45.33 still ends up 45.333300000000001

I have tried formatting again, copying and pasting values as well removing
the hyperlinks that are on these numbers.

What can I do to prevent this from happening? Is this an Excel or Word
problem?

I'm dealing with thousands of letters so I don't want to be manually fixing
all these numbers.

Thanks


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Database Mail Merge with Currency! WendyMc Mailmerge 9 December 11th 06 03:48 PM
Rounding of currency issue. rflitn Mailmerge 3 August 16th 06 06:05 AM
Currency in mail merge!! Jennifer Mailmerge 1 March 29th 06 04:59 AM
how do I print currency in mail merge doc? mathstar Mailmerge 3 October 23rd 05 06:12 AM
mail merge with currency Kelly Mailmerge 4 July 6th 05 01:05 AM


All times are GMT +1. The time now is 07:58 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"