format problems - mixed numbers/text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lee Harris web - 23 Jan 2004 12:04 GMT

Sorry if this post appears twice, but my Outlook Express seems not to
be posting so am doing this via the web.

I have a field that is importing a column of data from excel. most
items are just simple numbers, but some numbers have a character after
them (eg 7*), so are not importing properly but showing up as "0" in
the merge.

I think I just need a field code to make sure this item is formatted
as a text item but cannot find this anywhere, nor even a list of field
codes allowed in Words own help system

thanks in advance if anyone can help me with this

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 23 Jan 2004 13:57 GMT

Hi Lee,

Format the range in Excel as Text.

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

> Sorry if this post appears twice, but my Outlook Express seems not to
> be posting so am doing this via the web.
[quoted text clipped - 9 lines]
>
> thanks in advance if anyone can help me with this

Reply to this Message

Cindy M -WordMVP- - 23 Jan 2004 18:49 GMT

Hi Lee,

> Sorry if this post appears twice, but my Outlook Express seems not to
> be posting so am doing this via the web.
>

I'm not seeing it twice, so it's good that you've posted again :-) The
news servers were having some problems, yesterday, so that might explain
the problem you were having.

Doug's answer is basically correct, but doesn't tell you HOW you have to
force the data to be text. Look for the topic "Mail merge loses Excel
data" in the mail merge FAQ on my website.

> I have a field that is importing a column of data from excel. most
> items are just simple numbers, but some numbers have a character after
[quoted text clipped - 4 lines]
> as a text item but cannot find this anywhere, nor even a list of field
> codes allowed in Words own help system

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
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 :-)

Reply to this Message