How do I change a text column to a number column when merging?

[Guest]

When merging a document from Excel data as SQL into mail merge in Word, it
made the number column a text. We want it to be a number column. Couldn't
figure out how to do that even after reading all the help options.

Thanks,

Parish Secretary

 

[Cindy M -WordMVP-]

When merging a document from Excel data as SQL into mail merge in Word, it

made the number column a text. We want it to be a number column.

I'm having a bit of trouble figuring out exactly what you mean. Mail merge
with an Excel data source is clear. Which version of Word?

Can you give us an example of how Word is changing the number column to text?
As far as Word is concerned, EVERYTHING is text. But usually this won't
matter (you won't notice). What is Word doing in the mail merge result that's
a problem?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail