Tuesday, March 15, 2016

Troubleshooting:2010 Word & Excel Mail Merge - URGENT

2010 Word & Excel Mail Merge - URGENT

My problem is that when I do a mail merge from my Excel database to a word document the numbers from the spreadsheet do not transfer correctly.  I have the numbers formatted as a number with 2 decimal places and using the (,) separator for the 1000.  I
transfer whole numbers from the spreadsheet only to get weird numbers in the word document (i.e., 533.64 - in Excel - then transfers to word as 533.63999999999999997 or 533.6400000000000003).  Also if the number being transferred ends with a zero (5.90) it
drops the zero in the word document.

Any advice as a work around or fix to this?  Please advise.

Solutions to the Problem 2010 Word & Excel Mail Merge - URGENT

Download Error Fixer for Free Now

Word gets the number that is in the Excel cell, not the way it is displayed there.
There can be a profound, if subtle, difference between what a number
is, and how it looks, in either Excel or Word.
In Excel this difference can cause real problems when numbers are used as the basis for calculations.
The prime example is compound interest calculations.

You can either truncate the number in Excel, round it in Excel, or do that in Word.
You can also change the display in Word using field switches.
Field codes in Word - Word - Office.com
Mail Merge

Run CHKDSK

  • Go to the Start button.
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Reboot your computer.
NOTE: You might receive an error message that states:

"Access denied as you do not have significant privileges. You have to invoke this utility in elevated mode."

If you receive the above error message, it means you are not logged into you computer as an Administrator. If that's the case, follow these steps to run the command prompt in elevated mode:

  • Go to theStart button.
  • Go to "All Programs > Accessories" and right click on "Command Prompt".
  • Select "Run as Administrator".
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Reboot your computer.

Recommended Method to Repair the Problem: 2010 Word & Excel Mail Merge - URGENT:

 

 

How to Fix 2010 Word & Excel Mail Merge - URGENT with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will scan your computer. The errors will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed


Related: 1327 Invalid Drive Z Error Code 80004004 Error Code 137 80072ee7 Fix 3315 Error 26 3213 1726 0X6be Error Code 1393 Acaptuser32 dll Error 3050 Biosinfo dll,Fast Solution to Fix Error 1017 Received Logging On To The Standby Error,Installation Error 1706 Error Fixer,Loopback Failure Error - How to Fix,How to Fix Pro Registry Cleaner Error,How to Fix Win 7 Installation Error Code: 0x800705070 Error Quickly
Read More: Troubleshooting:12gb of shared graphic memory GONE !,Solution to Error: 2 GB of undeletable temporary files,Troubleshoot:2011 Word for Mac - My center alignment and all alignments for some reason, no matter what will move my whole paper instead of the highlighted text,How Can I Fix - 21997 error persists even after JRE ver 6 update 20. Why??,2 Questions- Uninstalling IE and windows security center [Solved],IE 8: Can't Send Page by Email AND Can't Send Link by Email,I can't connect to yahoo.com for online gaming after installing ex9 is there a problem?,c drive says full with 58gb and drive d has 219gb how to fromat drive c for more gb,Automatic Spelling Correction in MS Excel 2007,Attempting to install a financial program and getting error with regsvr32

No comments:

Post a Comment