Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-16-2014, 06:52 AM
VHV VHV is offline result of merge field is incorrect Windows 7 32bit result of merge field is incorrect Office 2007
Novice
result of merge field is incorrect
 
Join Date: Jun 2014
Posts: 2
VHV is on a distinguished road
Default result of merge field is incorrect

I have the following merge field from excell 2007 to word 2007.



[Mergefield "bank"\#"0,00"] but the result of this link is Always 0,00.

Do anyone know what's going wrong?
Reply With Quote
  #2  
Old 06-16-2014, 06:56 AM
macropod's Avatar
macropod macropod is offline result of merge field is incorrect Windows 7 32bit result of merge field is incorrect Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your mergefield code lacks some spaces that should be present:
{MERGEFIELD bank \# "0,00"}
I assumes the "0,00" reflects the fact you're using a language setting with a ',' decimal separator.

PS: Please don't hijack other peoples' threads by adding your issue as a new reply. Start your own thread instead.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-16-2014, 07:01 AM
VHV VHV is offline result of merge field is incorrect Windows 7 32bit result of merge field is incorrect Office 2007
Novice
result of merge field is incorrect
 
Join Date: Jun 2014
Posts: 2
VHV is on a distinguished road
Default

I also tried a dot '.' ( [Mergefield "bank"\#"0.00"] ) but this give de following result '000'. I never get the numbers from my excel with 2 decimales.
Reply With Quote
  #4  
Old 06-16-2014, 03:46 PM
macropod's Avatar
macropod macropod is offline result of merge field is incorrect Windows 7 32bit result of merge field is incorrect Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Depending on your system's regional settings, you should be able to get the desired results with either:
{MERGEFIELD bank \# ",0.00"}
or:
{MERGEFIELD bank \# ".0,00"}
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge multiple row sql query result chelios Mail Merge 1 05-23-2014 03:10 AM
result of merge field is incorrect Form field calculation returning 2x correct result Jschueller Word 1 08-20-2013 01:51 PM
result of merge field is incorrect How to ignore a mail merge field if the field is blank redzan Mail Merge 1 05-16-2013 08:34 AM
Merge field source data field kckay Mail Merge 4 03-25-2013 11:06 AM
result of merge field is incorrect lost data after incorrect merge changes response vthomeschoolmom Word 1 04-22-2012 04:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 AM.


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