Microsoft Office Forums Mail Merge Calculation Error

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2007, 01:12 PM
Lsbutler2000 Lsbutler2000 is offline
Novice
Mail Merge Calculation Error
 
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
Butch Jackman Butch Jackman is offline
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
Mail Merge Calculation Error 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 02:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft