A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Decimal places in mail merge



 
 
Thread Tools Display Modes
  #1  
Old April 29th, 2010, 07:04 PM posted to microsoft.public.word.docmanagement
BrookieOU
external usenet poster
 
Posts: 99
Default Decimal places in mail merge

I am trying to mail merge from an Excel spreadsheet and one of the fields I
am using is a calculated currency field (weekly pay). The problem I'm having
is because it is a calculated field the decimal point carries out to like 10
places. Here are the different steps I have tried to fix it, all to no avail:

1. In the Excel spreadsheet I have replaced the formulas with the values
and set the format to number with the decimal places at two. In the merge it
still carries it out 10 or so places.

2. In the Excel spreadsheet I have set the values format as general, with 2
decimal places. In the merge it still carries it out 10 or so places.

3. I have physicall gone and re-typed the values in Excel so that there
were only 2 decimal places physically entered in the cell. If I set the cell
format to text it merges fine. But, if I set the cell value to number (so I
can have the thousands comma) some of the values it will still carry out 10
places even though I only physically entered 2 numbers after the decimal
place. For example. The first number is typed in Excel as 1870.22 and that
merges fine. The next number is typed in Excel as 1321.15 but it merges
1321.150000000001. Those other numbers were never typed in and I can't
figure out why it is arbitrarily picking numbers to do that to!

I have already gone in and just set all the numbers to text and am
physically adding the commas in, but I was wondering if anyone knew the
answer or reason behind this. It's driving me crazy!
  #2  
Old April 29th, 2010, 07:30 PM posted to microsoft.public.word.docmanagement
Suzanne S. Barnhill
external usenet poster
 
Posts: 31,786
Default Decimal places in mail merge

You need to add a "numeric picture" switch to format the incoming number.
See http://www.gmayor.com/formatting_word_fields.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

"BrookieOU" wrote in message
...
I am trying to mail merge from an Excel spreadsheet and one of the fields I
am using is a calculated currency field (weekly pay). The problem I'm
having
is because it is a calculated field the decimal point carries out to like
10
places. Here are the different steps I have tried to fix it, all to no
avail:

1. In the Excel spreadsheet I have replaced the formulas with the values
and set the format to number with the decimal places at two. In the merge
it
still carries it out 10 or so places.

2. In the Excel spreadsheet I have set the values format as general, with
2
decimal places. In the merge it still carries it out 10 or so places.

3. I have physicall gone and re-typed the values in Excel so that there
were only 2 decimal places physically entered in the cell. If I set the
cell
format to text it merges fine. But, if I set the cell value to number (so
I
can have the thousands comma) some of the values it will still carry out
10
places even though I only physically entered 2 numbers after the decimal
place. For example. The first number is typed in Excel as 1870.22 and
that
merges fine. The next number is typed in Excel as 1321.15 but it merges
1321.150000000001. Those other numbers were never typed in and I can't
figure out why it is arbitrarily picking numbers to do that to!

I have already gone in and just set all the numbers to text and am
physically adding the commas in, but I was wondering if anyone knew the
answer or reason behind this. It's driving me crazy!


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:08 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.