Reply
 
Thread Tools Display Modes
  #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


  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Jezebel Jezebel is offline
external usenet poster
 
Posts: 1,384
Default Mail Merge Currency Issue

The problem is at the Excel end. The quick fix is to set 'precision as
displayed'.


" wrote in
message ...
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




  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Mail Merge Currency Issue

See http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

" wrote in
message ...
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



Reply
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 08:56 PM.

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

About Us

"It's about Microsoft Word"