Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-19-2007, 01:12 PM
Novice
 
Join Date: Apr 2007
Posts: 1
Lsbutler2000
Default Mail Merge Calculation Error

I am working on a mail merge that has two fields that are percentages. Instead of showing as 3.75%, it shows as 3.744444444444444444444444E-2 or whatever.

I used this to try to correct it and have spaced it and formatted it about 20 different ways and it still does not seem to work, what am i doing wrong?
{= {«Proposed_Merit_Increase_»} * 100 \# “0% ”}
Reply With Quote
  #2  
Old 06-22-2007, 06:33 AM
Novice
 
Join Date: Oct 2005
Location: Mankato, Minnesota
Posts: 11
Butch Jackman
Default Mail Merge

Make sure that the field is already rounded in the Excel or Access file.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Query kangabanga Mail Merge 0 09-25-2008 04:07 AM
Merge mail not working jdpowell@brazoriainet.com Mail Merge 1 07-25-2008 07:51 PM
mail merge in word help jngovols Mail Merge 0 04-07-2008 05:40 AM
Word mail merge and formula mridley Mail Merge 0 04-30-2006 11:26 AM
HELP! Mail Merge! I'm an idiot mtomto Mail Merge 0 02-15-2006 04:05 AM


All times are GMT -7. The time now is 07:11 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft