Decimal Place Format!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NickH - 08 Apr 2004 11:55 GMT

Hi

I am trying to merge data into fields in Word 2002 from
Access 2002.
The data format in the Access 2002 is displayed as shown
here:

Freq
0.009 MHz

However if I merge this using the Word 2002 View data the
data displayed is shown here:

Freq
8.9999999999-E3

Is there anyway of displaying the latter as shown in the
Former i.e., 0.009

Any help would be most appreciated

Thanks

Nick

Reply to this Message

Doug Robbins - Word MVP - 08 Apr 2004 13:34 GMT

In the mailmerge main documnet, select the mergefield and use Shift+F9 to
toggle on the field code, then add the following formatting switch inside
the closing }

\# "0.000"

Alternatively, create a query in Access as use the Format() function on that
field to force the formatting that you want.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Hi
>
[quoted text clipped - 20 lines]
>
> Nick

Reply to this Message

NickH - 08 Apr 2004 13:47 GMT

Hi Doug

Thank you it has worked a treat.

Nick

>-----Original Message-----
>In the mailmerge main documnet, select the mergefield and use Shift+F9 to
[quoted text clipped - 32 lines]
>
>.

Reply to this Message

Rick Perry - 09 Apr 2004 06:39 GMT

Thanks!!! Thanks!!! Thanks!!!

You just solved my problem as well.

>-----Original Message-----
>In the mailmerge main documnet, select the mergefield and use Shift+F9 to
[quoted text clipped - 32 lines]
>
>.

Reply to this Message