View Single Post
  #1  
Old April 28th, 2005, 06:52 AM
punkyh
external usenet poster
 
Posts: n/a
Default decimal spaces toolong when mail merging from excel

I recive data in an excel spreadsheet that contains in one column a number
expressed as " 5.55" which is supposed to be a percentage, but when I try to
mailmerge the data, it mailmerges as "5.55061561650660". In other words it
carries out the decimal place more than 2 digits, which is not what I want. I
have tried formatting the cell, rounding, hand typing the information in
another column and deleting the column that contained the original
information (which I am sure was edited from 5.55061561650660.) How can I fix
this problem so that when I mail merge it comes out as "5.55" only?