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

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
rflitn rflitn is offline
external usenet poster
 
Posts: 2
Default Rounding of currency issue.

I neglected the fact that the data is being brought in from an Excel
spreadsheet.

rflitn wrote:
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 [mergefield 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!


  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Rounding of currency issue.

Well, the best thing is probably to add a couple of columns to the Excel
spreadsheet and use Excel superior ability to get what you want.

Alternatively in Word, you can probably do

{ = ({ MERGEFIELD mergefield box_a \# "0,00;;" } - { MERGEFIELD mergefield
box_a \# ".00;;" }) \# "0;;" }

for the dollar amount.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"rflitn" wrote in message
ups.com...
I neglected the fact that the data is being brought in from an Excel
spreadsheet.

rflitn wrote:
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 [mergefield 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!




  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Rounding of currency issue.

To get the unrounded dollar amount you need

{ =INT({ Mergefield box_a }) \# ",0;;" }

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


rflitn wrote:
I neglected the fact that the data is being brought in from an Excel
spreadsheet.

rflitn wrote:
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 [mergefield 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!



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
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 12:22 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"