Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 04-19-2007, 01:12 PM
Lsbutler2000 Lsbutler2000 is offline
Mail Merge Calculation Error
Join Date: Apr 2007
Posts: 1
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
Old 06-22-2007, 06:33 AM
Butch Jackman Butch Jackman is offline
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

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 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:01 PM.

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