Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
worksheet text converter
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 |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
worksheet text converter
See 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 "Old Bob" wrote in message ... 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
worksheet text converter
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 toolsoptionsGeneral 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! -- Old Bob "Doug Robbins - Word MVP" wrote: See 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 "Old Bob" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ADD A WATERMARK TO A TEXT BOX | Microsoft Word Help | |||
Arcane Question @ Text Boxes & "Frames" | Page Layout | |||
autoshape text wrapping | Page Layout | |||
Wandering text box | Microsoft Word Help | |||
Way to hide text without hidden text font? | Microsoft Word Help |