worksheet text converter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Old Bob - 08 Sep 2006 17:28 GMT

when I mail merge and choose an excel spreadsheet as the source I used to get
a box that said It will run an sql command and then a box saying it needed to
use the excel worksheet text converter--I said yes and all was good. Now, I
do not get that second box but get a box called data link properties. No
matter what I do, my numbers are going back to the old incorrect way of
displaying 59.36 as 59.350000003. I have word 2003 sp2-can anyone help?
Old Bob

Reply to this Message

Doug Robbins - Word MVP - 08 Sep 2006 19:00 GMT

See 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

> when I mail merge and choose an excel spreadsheet as the source I used to
> get
[quoted text clipped - 6 lines]
> displaying 59.36 as 59.350000003. I have word 2003 sp2-can anyone help?
> Old Bob

Reply to this Message

Old Bob - 08 Sep 2006 20:09 GMT

Just in case anyone else is having this problem. I found some old notes that
corrected the problem very easily. In word I went to tools>options>General
tab and make sure the box labeled "confirm conversion at open" is checked.
then when you merge it asks what conversion you want to use and I selected
the excel one and it works fine again. Thanks for your help and allowing me
to share some good news!

Signature

Old Bob

> See http://www.gmayor.com/formatting_word_fields.htm
>
[quoted text clipped - 8 lines]
> > displaying 59.36 as 59.350000003. I have word 2003 sp2-can anyone help?
> > Old Bob

Reply to this Message