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

[warbara]

I merged nos from an excel spreadsheet into a chart in a memo done in word.
I formatted the nos in excel to 0 or 2 decimal places but when they merge
into excel I get 6-7 numbers after decimal and have to go in on each memo and
delete the extra numbers. How can I get these extra decimal places not to
come in when merging?

 

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
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

 

[barbaralou]

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???????

 

[Doug Robbins - Word MVP]

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

 

[barbaralou]

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

 

[barbaralou]

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...