Excel to Mail Merge
 

We are producing invoices in mail merge using data obtained from Excel.
Most merge fields come accross correctly using \#"$0.00" formatting. However
one field which is the last field of 155 is producing a totally different
number. It is converting 0.1171 to $87.0000 into the invoice. This should be
$0.1171 which all of the other fields are doing correctly using the same
formatting.
Can you suggest a solution...?

Excel to Mail Merge
 

Format the formula cell to the date format of your choice


"Stuart" wrote:

We are producing invoices in mail merge using data obtained from Excel.
Most merge fields come accross correctly using \#"$0.00" formatting. However
one field which is the last field of 155 is producing a totally different
number. It is converting 0.1171 to $87.0000 into the invoice. This should be
$0.1171 which all of the other fields are doing correctly using the same
formatting.
Can you suggest a solution...?

Excel to Mail Merge
 

Hi Stuart, please ignore the previous post


"Jacob Skaria" wrote:

Format the formula cell to the date format of your choice


"Stuart" wrote:

We are producing invoices in mail merge using data obtained from Excel.
Most merge fields come accross correctly using \#"$0.00" formatting. However
one field which is the last field of 155 is producing a totally different
number. It is converting 0.1171 to $87.0000 into the invoice. This should be
$0.1171 which all of the other fields are doing correctly using the same
formatting.
Can you suggest a solution...?

Excel to Mail Merge
 

Hi Stuart,

Check that the value in Excel has been input correctly. Data entry errors can turn numbers into a series of strings that Word will
try to evaluate under some circumstances.

--
Cheers
macropod
[Microsoft MVP - Word]


"Stuart" wrote in message ...
We are producing invoices in mail merge using data obtained from Excel.
Most merge fields come accross correctly using \#"$0.00" formatting. However
one field which is the last field of 155 is producing a totally different
number. It is converting 0.1171 to $87.0000 into the invoice. This should be
$0.1171 which all of the other fields are doing correctly using the same
formatting.
Can you suggest a solution...?