Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
rflitn rflitn is offline
external usenet poster
 
Posts: 2
Default Rounding of currency issue.

I have created a mail merge in Word that brings in currency. I need to
populate the dollar and cents in two separate fields, basically taking
the currency entry in the excel spreadsheet (ie: 100.55) and parse it
to 100 and .55.

I've accomplished this with the proper field :
mergefield box_a [mergefield box_a\#"0;;"]
and
mergefield box_a [emrgefield box_a\#".00;;"]

However, it rounds the dollar amount (ie: 100.55 would come up as 101
and .55).

I need to prevent the rounding, keeping it accurate. Is there either an
addition to the above or a better method? Thanks in advance!

 
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
Formatting for Currency Louisq Microsoft Word Help 2 July 14th 06 04:58 PM
Right-to-left issue (how to default to left-to-right) JeePee Microsoft Word Help 0 October 21st 05 02:53 PM
Currency fields in Access lose th currency format whn merged why PMasters Mailmerge 1 June 1st 05 08:13 PM
How do you keep the currency format when merging data from Excel? MJW Mailmerge 2 February 22nd 05 06:33 PM
Currency in merge from Excel tony Microsoft Word Help 1 February 7th 05 11:59 PM


All times are GMT +1. The time now is 02:44 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"