decimal spaces toolong when mail merging from excel
It works. I tried.
"punkyh" wrote:
Thank you for the quick response!
I have done this and it still doesn't work.
"Peo Sjoblom" wrote:
Try toolsoptionscalculations and select precision as displayed before
doing the mailmerge
--
Regards,
Peo Sjoblom
"punkyh" wrote in message
...
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?
|