View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stuart Stuart is offline
external usenet poster
 
Posts: 62
Default 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...?