View Single Post
 
Old 08-15-2012, 09:46 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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 currency values have all been input as text. You can see this from the fact they're right-aligned and are prefixed with '. Where you have numerous empty cells or mixed numbers and text in the first 16 rows in a column, you are liable to have 0s instead of the text in the mailmerge output.

You can remedy the problem by inputting a 1 in an unused cell, copying it, then selecting the blocks of numeric text and using Paste Special > Values > Multiply.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote