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