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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

warbara - 14 May 2008 16:24 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 14 May 2008 20:23 GMT

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

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

Signature

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

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

Reply to this Message

barbaralou - 15 May 2008 23:03 GMT

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

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 7 lines]
> > delete the extra numbers. How can I get these extra decimal places not to
> > come in when merging?

Reply to this Message

Doug Robbins - Word MVP - 16 May 2008 03:08 GMT

It can be fixed the same way.

Signature

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

>I am having this same issue,,, sort of. I mail merging info from access
>into
[quoted text clipped - 17 lines]
>> > to
>> > come in when merging?

Reply to this Message

barbaralou - 16 May 2008 15:38 GMT

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

> It can be fixed the same way.
>
[quoted text clipped - 19 lines]
> >> > to
> >> > come in when merging?

Reply to this Message

barbaralou - 16 May 2008 15:58 GMT

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

> 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
[quoted text clipped - 22 lines]
> > >> > to
> > >> > come in when merging?

Reply to this Message