How can I stop Merged nos. from excel having 6-7 nos after dec

How can I stop Merged nos. from excel having 6-7 nos after dec

Post by YmFyYmFyYW » Sat, 17 May 2008 07:03:01


I am having this same issue,,, sort of. I mail merging info from access into
a word doc. The zero's after the decimal are being left off. EX: if it is
68.30: 68.3 comes over, it the amount is 68.00: 68 comes over.
Any thought on why this is happening???????
 
 
 

How can I stop Merged nos. from excel having 6-7 nos after dec

Post by Doug Robbi » Sat, 17 May 2008 11:08:24

It can be fixed the same way.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 
 
 

How can I stop Merged nos. from excel having 6-7 nos after dec

Post by YmFyYmFyYW » Sat, 17 May 2008 23:38:00

That worked!!! thanks!! However, when the numbers were merged, there are
spaces in between them: ex: 3 0 . 6 0 How do I get rid of those
 
 
 

How can I stop Merged nos. from excel having 6-7 nos after dec

Post by YmFyYmFyYW » Sat, 17 May 2008 23:58:00

Never mind!!! I figured it out!!! Thanks again for your help! The way I fixed
this is by omitting teh ;(0.00) in my mergefiled switch...